Senior Database Administrator
FlightSafety International•Fort Worth, TX
•Onsite
About The 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.
Requirements
- 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)
- 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
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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Job Type
Full-time
Career Level
Senior
