What are the responsibilities and job description for the Sr Database Administrator position at IS3 Solutions?
Job purpose
This role is responsible for developing database administration, Change Management, and Data Governance for data repositories, platforms, tools, and development. In this role, you are expected to work closely with the database administration team, the development teams (Systems Mainframe, Systems Development, and Systems Engineering) as well as the Infrastructure team in the design, implementation, transition, and maintenance of data solutions and ensuring associated standards and best practices for enterprise data management. This position requires 8 years of experience in Microsoft SQL Server 2016 / 2017 / 2019 / 2022. This position reports to the Vice President of Database Administration.
Duties and responsibilities
- Performing hands-on technical DBA work, including requirements gathering, data / database / ETL architecture analysis / design as part of database administration
- Proactively monitor and performance-tune databases and troubleshoot bottlenecks and system performance at the network, storage, and database levels.
- Establish regular maintenance routines for backup, recovery, and optimization plans, data archive processes, data retention plans, and data corruption checks
- Support developers in designing performant, scalable, and optimized objects and queries
- Provide support to Production / Staging / UAT / QA / Development databases, jobs and transactions processes
- Follows and enforces the change control policies and database lifecycle management process
- Install, configure, upgrade, and administer database platforms, tools, and utilities (Primarily, but not limited to, MS SQL Server)
- Develop and maintain scripts for database automation tasks using PowerShell, T-SQL, or AWS CLI
- Track and report daily metrics on up-time, utilization, logins, blocking, locking, etc.
- Ability to understand complex business problems and communicate with developers, quality assurance, and management
- Manage the AWS database environment
- Peer review all database / SQL changes as part of the change management process
- Create SSRS reports, standardized SQL reports, and ad-hoc reports
- Create and manage SSAS OLAP cubes or any other data warehouse solutions.
- Restore databases for developers and QA
- Implement database security standards
Qualifications
