SQL Server Database Administrator

Precision Castparts - Toronto, OH

Full-time - Mid Level

Toronto, OH

10,001+ employees

Primary Metal Manufacturing

About the position

The SQL Server Database Administrator at Precision Castparts Corp. (PCC) is responsible for the implementation, configuration, maintenance, and performance management of critical SQL Server RDBMS systems. This hands-on role requires solid technical skills and excellent interpersonal abilities to ensure the availability and consistent performance of division applications. The successful candidate will develop and sustain the SQL Server environment, ensuring operational readiness, executing data loads, and performing data modeling in support of multiple development teams.

Responsibilities

• Provide project and enhancement work on a range of new and existing SQL Server databases.
• Perform routine administration and performance monitoring activities to ensure optimal operation of the SQL Server databases.
• Provide advice and guidance where necessary to development staff.
• Complete tickets assigned and other requests within a mutually agreed upon time.
• Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
• Refine and automate regular processes, track issues, and document changes.
• Assist developers with complex query tuning and schema refinement.
• Provide support outside of normal office hours on a pre-planned basis and at short notice in emergency situations.
• Participate in continuous process improvement.
• Download and install SQL Server service packs and updates.
• Configure and maintain SQL Security controls.
• Create, change, and improve SQL Server Agent tasks and maintenance plans.
• Create documentation and training for routine database administration activities.
• Stay abreast of new technologies related to areas of responsibility.
• Identify problem trends and proactively take action to reduce re-occurring incidents.
• Crosstrain developers and server administrators on good database design.
• Proactively monitor and report on system resources being consumed.

Requirements

• 5+ years MS SQL Server Administration experience required.
• Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
• Experience with backups, restores and recovery models.
• Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.
• Experience with SQL and PowerShell scripting.
• Experience working with Windows server, including Active Directory.
• Experience with cloud services (Microsoft Azure, AWS) a plus.
• Microsoft Certified: Azure Database Administrator Associate certifications a plus, or equivalent experience.
• Excellent written and verbal communication.
• Excellent problem-solving skills.
• Experience in building relationships with peers and customers.
• Effectively present information in one-on-one and small group situations to functional groups.
• Excellent documentation skills leading to effective standard operating procedures.
• Strong troubleshooting and analytical skills.
• Ability to organize and plan work independently.
• Ability to work in a rapidly changing environment.
• Ability to multi-task and context-switch effectively between different activities and teams.

Nice-to-haves

• Experience with cloud services (Microsoft Azure, AWS) a plus.
• Microsoft Certified: Azure Database Administrator Associate certifications a plus, or equivalent experience.

Benefits

• Full-time employment with a leading company in the aerospace industry.
• Opportunities for professional development and continuous learning.
• Hybrid workplace model allowing for flexibility in work location.