In compliance with company policies and procedures, the Senior Database Administrator is responsible for design, engineering, installation, monitoring, automation, alerting, space management, database backup, recovery, configuration, and maintenance in both Windows and Azure environments. The Senior Database Administrator will be required to assist with appropriate data engineering tasks to connect data within our various environments. In addition, communication, documentation, security measures, and best practice guidelines in the Aqua Finance environment will need to be carried out.
Essential Functions
Database performance tuning and monitoring
Database server patching, upgrades, and security hardening
Planning, deploying, and documenting of new Windows Server, Azure SQL Server, and Azure SQL Server Managed Instance based databases and the data and tables located within.
Implementing proper security controls and routinely manage and audit access to servers.
Writing SQL queries for purposes of creating, retrieving, and manipulating data and reports
Suggesting proper SQL hygiene and data architecture reviews to Aqua developers building various databases for transaction processing.
Committing SQL changes through DACPAC (Data Tier Application Package) and utilizing version control when applying changes to the DACPACs
Presenting changes as required during a weekly CAB meeting.
Participating in an on-call rotation schedule for occasional maintenance, outages, and product release support
Provide mentorship, guidance, and assistance to the Database Administrator(s) on the team.
Other duties as assigned.
Required Education and Experience
Bachelor’s degree in Information Systems or Computer Science, or related field, or commensurate work experience required
5 years of related work experience with progressively elevated roles required
3 years of experience with Windows SQL Server 2017, 2019, or 2022
Extensive knowledge of SQL Language
Extensive knowledge of MS SQL Server & Azure SQL Server / Managed Instances
Experience with Postgres a plus
Familiar with Jira and Bitbucket/git
Familiar with PostgreSQL
Financial industry experience preferred
Attention to detail and accuracy required.
Excellent verbal and written communication skills required.
Physical Demands
While performing the duties of this job, the employee is frequently required to sit, stand, walk, visualize, talk, hear, and handle or touch objects or controls. The employee may occasionally lift, push, or pull up to 20 pounds.
This position is an office-based position where you must be able to sit for extended periods of time. The employee will be working on a computer 90% of the time.
Seniority level
Mid-Senior level
Employment type
Full-time
Job function
Information Technology
Industries
Financial Services
Referrals increase your chances of interviewing at Aqua Finance, Inc. by 2x