Sr. SQL DBA/Developer

This role is responsible for production and development database administration, Change Management and Data Governance for data repositories, platforms, tools and development. In this role you are expected to work closely with our Database Administrator team, development team and 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 5 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
• Install, configure , upgrade and administer database platforms, tools and utilities (Primarily, but not limited to, MS SQL Server)
• Establish regular maintenance routines for backup, recovery and optimization plans
• Proactively monitor and performance tune databases and troubleshoot bottlenecks and system performance at the network, storage and database levels.
• Support developers to design performant, scalable and optimized objects and queries
• Provide support to Production/Staging/Development databases, jobs and transactions processes
• Follows and enforces the change control polices and database lifecycle management process
• Track and report daily metrics on up-time, utilization, logins, blocking, locking, etc.
• Ability to understand complex business problems and clearly communicate with developers and management
• Restore databases for developers and QA.
• Create and manage SSAS OLAP cubes.

Qualifications

• 5 + 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 backups, restores and recovery models
• Experience with Transactional Replication
• Experience in implementing operational automation using PowerShell Scripts
• 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 7x24 Production database environments
• Experience with SSAS, OLAP cubes and data warehouses.