About
The Lead Database Administrator (Lead DBA) is responsible for supervising and managing the daily activities of the Database Administration team. This includes ensuring the deployment, configuration, patching, and upgrades to database servers and client installs in a mixed technology environment to deliver data products providing business decision support focusing on Oracle and MS-SQL server production support. Tasks and responsibilities include: Supervising the daily activities and workflow of the database administration team, managing performance and providing feedback when needed Ensuring that database servers are appropriately deployed, configured, upgraded, and supported in a 24x7 production environment. Troubleshooting and fixing problems and providing root cause analysis that the database administration team has escalated in a timely manner Automating maintenance tasks Developing, managing, testing, and executing backup and recovery plans Ensuring processes are documented, followed, and regularly updated Managing security and disaster recovery aspects of a database Evaluating SQL Server performance and taking appropriate steps for performance improvement Participating in on-call rotation for after hours and weekend work Prioritizing and managing workload and communicating issues clearly Completing other tasks as required Travel when required Minimum education and experience required: Bachelor's degree from an accredited institution or equivalent industry experience 8+ years of experience in relational database design, development, and implementation in a Microsoft SQL Server environment working primarily as a Database Administrator (DBA) Proficient with TSQL and Powershell Knowledge, skills, and abilities: Experience administering production level high performance, high transaction volume, and highly available OLTP databases Ability to create and maintain database documentation and diagrams Proven experience in database performance monitoring and tuning operations Experience implementing database security protocols Knowledge of current DBMS products as well as knowledge of related technologies, applications, and processes Knowledge of relational database internals, objects, and processes, as well as best practice principles regarding availability, performance, and security Experience working with high availability tools, particularly Availability Groups Experience writing shell scripts to automate Database activities Demonstrated skill using database backup and recovery models, utilities, and best practices Experience with Agile development methodology Excellent analytical skills Excellent interpersonal skills Ability to perform various tasks in a fast-paced, production-critical support environment Strong written and verbal communications skills Excellent organizational skills, including the ability to multi-task and prioritize workload. Nice to haves: Experience with Postgres, MySQL, MariaDB, Oracle, CosmosDB, or Azure Experience with CIS and DOD Stig security standards Experience with Azure Devops for managing work Experience in a culture that requires change approvals Physical demands and work environment: The physical demands and work environment described here are representative of those that must be met and/or encountered by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is regularly required to use hands to finger, handle, or feel; reach with hands and arms; and communicate. The employee may be required to stand, walk, and sit. Specific vision abilities required by this job include the ability to view monitors, technical documents, and reference material. The employee must occasionally lift or move up to 25 pounds. The noise level in the work environment is usually low to moderate. FlightSafety is an Equal Opportunity Employer/Vet/Disabled. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or disability.
Languages
- English
Notice for Users
This job comes from a TieTalent partner platform. Click "Apply Now" to submit your application directly on their site.