Job Description
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 - 8+ Years of experience with Database Administration for MS-SQL Server
- Experience in troubleshooting and resolving database problems
- A deep understanding of technical database and development work, the impact of logical design decisions on the technical database and application infrastructures
- Experience in Performance Tuning and Optimization (PTO), using native monitoring and third-party troubleshooting tools
- Experience with SSAS, OLAP cubes, data warehouses, MDX queries
- Experience with SSIS packages, ETL implementation, and troubleshooting
- Experience with SSRS technology, designing reports
- Experience with backups, restores, and recovery models
- Experience with Snapshot & Transactional Replication
- Experience in implementing operational automation using PowerShell Scripts
- Experience with AWS
- Experience with database encryption technology
- Experience with SnowFlake
- Knowledge of indexes, index management, and statistics
- Strong understanding of database architecture, physical infrastructure, and storage systems
- Good communication and documentation skills
- BS or BA in a business or computer science-related field of study
- Experience managing and monitoring 24/7 Production database environments
Job Tags