Project description
the database administration team, performs database and production operational functions in support of sql server environments across multiple cdos. We are looking for a sr. Sql server dba with expertise in all areas of sql server to support database management, security, performance tuning, capacity planning, high availability, disaster recovery, and lifecycle management. This role will be interfacing with multiple teams to meet business objectives and deliverables. The ability for the candidate to work independently, with strong communication and organizational skills, is required.
responsibilities
* assess the health of the database environment, troubleshoot issues, and determine course of action for resolution.
* ensure proactive monitoring, notification, and maintenance is in place to optimize the availability and performance of systems and applications.
* perform database management activities with planning for security, performance, and scalability.
* automate operational processes.
* provide and implement solutions for high availability and disaster recovery of critical databases.
* perform capacity planning and management to ensure databases are adequately configured to support business growth.
* facilitate dialog across functional areas and provide consultative direction.
* deploy system and application database changes in accordance with change management procedures.
* evaluate lifecycle management requirements and implement solutions.
skills
must have
* undergraduate degree or equivalent
* 7+ years of sql server database administration experience
* 5+ years of sql language and transact-sql experience
* 5+ years of experience with sql server always on availability groups
* 5+ years of experience with sql server integration services, reporting services, analysis services
* 3+ years of experience with 3rd party database backup solutions
* 2+ years of experience with sql server on a cloud platform
* proficient in troubleshooting performance issues using native monitoring and troubleshooting tools
* experience with sql server 2012 thru 2022 to support sql server upgrades
* experience automating processes with powershell
* strong communication and organizational skills
nice to have
* leadership skills
#j-18808-ljbffr