Sql database developer Jobs in USA

About FlightSafety International

FlightSafety International is the world’s premier professional aviation training company and supplier of flight simulators, visual systems and displays to commercial, government and military organizations. The company provides training for pilots, technicians and other aviation professionals from 167 countries and independent territories. FlightSafety operates the world’s largest fleet of advanced full-flight simulators and award-winning maintenance training at Learning Centers and training locations in the United States, Canada, France and the United Kingdom.

Purpose of Position

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

• Supervise the daily activities and workflow of the database administration team, managing performance and providing feedback when needed
• Ensures that database servers are appropriately deployed, configured, upgraded, and supported in a 24x7 production environment.
• Troubleshoot and fix problems and provide root cause analysis that the database administration team has escalated in a timely manner
• Automate maintenance tasks
• Develop, manage, test, and execute backup and recovery plans
• Ensure processes are documented, followed, and regularly updated
• Manage security and disaster recovery aspects of a database
• Evaluate SQL Server performance and take appropriate steps for performance improvement
• Participate in on-call rotation for after hours and weekend work
• Prioritize and manage workload and communicate issues clearly
• Complete other tasks as required
• Travel when required

Minimum Education

• Bachelor's degree from an accredited institution or equivalent industry experience

Minimum 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, 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