Senior Database Administrator

FlightSafety International Inc; Columbus (OH); On-site; USD 110,000 - 140,000; Full time

Job summary

FlightSafety International is seeking a Senior Database Administrator to deploy, configure, patch, and upgrade Oracle and SQL Server environments to deliver reliable data for decision support. The role requires 5+ years in relational DB design and hands-on experience with Oracle and MS SQL Server, plus scripting skills.

The position includes 24x7 on-call support, disaster recovery planning, performance tuning, and mentoring of teammates.

Qualifications

• 5+ years in relational database design, development and implementation in MS-SQL or Oracle.
• Proficient in Oracle 11g/12c and SQL Server 2014+ and related technologies.
• Experience with backup/recovery models and performance tuning.
• Scripting to automate database tasks and create documentation.

Responsibilities

• Deploy, configure, patch, and upgrade database servers in Oracle and SQL Server.
• Troubleshoot issues and provide root cause analysis in a timely manner.
• Develop, manage, and test backup and recovery plans.
• Design OLTP/OLAP environments and monitor performance.
• Provide 24x7 on-call support and mentoring to team members.
• Carry out capacity planning and ensure security and DR aspects.

Skills

Relational database design

SQL Server performance tuning

Oracle database experience

Shell scripting for DB tasks

C#.NET programming

Agile development

Education

Bachelor's degree

Tools

Oracle

SQL Server

AlwaysOn/DataGuard

Azure DevOps

Job description

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 Senior Database Administrator (Sr. DBA) is responsible for deploying, configuring, patching, and upgrading 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

• Deploy, configure, patch, and upgrade database servers and client installs, with a focus on Oracle server production support
• Troubleshoot and fix problems and provide root cause analysis in a timely manner
• Perform preventive maintenance and system copies
• Automate system maintenance tasks
• Develop, manage and test backup and recovery plans
• Ensure storage and archiving processes are functioning correctly
• Write database documentation, including data standards, procedures, and data dictionary
• Carry out capacity planning
• Manage security and disaster recovery aspects of a database
• Evaluate SQL Server performance and take appropriate steps for performance improvement
• Provide 24x7 on call support, after-hours and weekend work as needed
• Relational database design and development
• Design OLTP and OLAP environments, and monitor, detect, and tune performance
• Provide guidance and mentoring to other team members as needed
• Accountable and responsible for the accuracy and completeness of assigned work and results
• Prioritize and manage workload and communicate issues clearly
• Complete other tasks as required
• Travel when required
• Bachelor's degree from an accredited institution or equivalent industry experience
• 5+ years of experience in relational database design, development, and implementation in an MS-SQL or Oracle environment
• Strong experience in the use of programming languages (i.e., C#.NET, Flash, HTML5, Transact SQL, and later versions including stored procedures)

Knowledge, Skills, Abilities

• Experience administering production level high performance, high transaction volume, and highly available OLTP databases (Oracle and SQL Server)
• Ability to create and maintain database documentation and diagrams
• Knowledge of database performance monitoring and tuning operations
• Knowledge of database security protocols
• Knowledge of current DBMS products, primarily Oracle 11g and 12c and SQL Server 2014+, 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 DataGuard or AlwaysOn
• Experience Installing OEM and configuring to monitor Oracle instances
• Experience writing shell scripts to automate Database activities
• Demonstrated skill using database backup and recovery models, utilities, and best practices
• Familiar 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 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.

Any offer of employment is contingent upon successful completion of required compliance reviews, including verification that the candidate is not prohibited from employment under U.S. economic sanctions programs administered by the U.S. Department of the Treasury's Office of Foreign Assets Control (OFAC).

This position may require access to export-controlled technology or services subject to the International Traffic in Arms Regulations (ITAR) and/or the Export Administration Regulations (EAR). Employment consideration and any offer of employment are contingent upon the applicant's ability to comply with these requirements, including qualifying as a "U.S. Person" under applicable regulations or otherwise eligible for export authorization within a timeframe consistent with business needs. A "U.S. Person" includes U.S. citizens, lawful permanent residents (holders of approved and unexpired green cards), and certain refugees or asylees with protected status under U.S. law.

This position may also require eligibility to obtain and maintain a U.S. Government security clearance for the duration of employment.

Cybersecurity Notice: All official recruiting communication from FlightSafety International will come from an @flightsafety.com email address. FlightSafety International will never ask for personal or financial information through social media or third-party email providers.