Senior SQL Database Administrator

Job Summary

General Atomics (GA), and its affiliated companies, is one of the world's leading resources for high-technology systems development ranging from the nuclear fuel cycle to remotely piloted aircraft, airborne sensors, and advanced electric, electronic, wireless and laser technologies.

We have an exciting opportunity for a Sr. SQL Database Administrator to join our SAP Systems team in San Diego, CA.

Under general direction of the DBA Group Manager, this position is responsible for developing, planning and coordinating the development of reporting infrastructure within the enterprise that supports lot of data flow and analytics serving critical reports, administration of SQL Server databases, to ensure accurate, appropriate and effective use of data, including database definition, structure, documentation, long-range requirements, and operational guidelines. Develops technical solutions to moderately complex problems. Performs quality control audits to ensure accuracy, completeness and proper usage of data in table and various report tools including Business Objects, Power BI and database dictionaries. Develops technical solutions to a wide range of complex problems and may provide direction to less experienced staff.

DUTIES AND RESPONSIBILITIES:

• Administer and manage Microsoft SQL databases; administer and manage software programs; design and develop DBA components.
• Database performance tuning, troubleshooting and problem resolution.
• Install, patch, and upgrade SQL Server Databases; develop SQL program instructions.
• Provide appropriate consulting, interfacing and training for information system users.
• Collaborate with all the Business Users, Application End Users to understand the reporting requirements and develop innovative solutions to provide the necessary reports utilizing various web interfaces and programming tools.
• Import, export and back-up data between different software programs as required.
• Perform software enhancement testing prior to release for production use.
• Develop, maintain and enhance intranet software.
• Review and analyze database design and integration of systems, recommend enhancements and/or improvements.
• Develop procedures and standards relating to database management and monitor transaction activity and utilization.
• Maintain the strict confidentiality of sensitive information.
• Responsible for observing all laws, regulations and other applicable obligations wherever and whenever business is conducted on behalf of the Company. Expected to work in a safe manner in accordance with established operating procedures and practices.
• Tracking and resolving database related incidents and requests
• Fulfilling requests and resolving incidents within SLAs,
• Reviewing service-related reports (e.g.: database backups, maintenance, monitoring) on a daily basis to ensure service-related issues are identified and resolved within established SLAs
• Responding effectively to database monitoring alerts and escalations
• Collaborate with Application, Business and Database teams to come up with well-defined and strategic solutions to recurring problems.
• Other duties as assigned or required.

We recognize and appreciate the value and contributions of individuals with diverse backgrounds and experiences and welcome all qualified individuals to apply.

Job Qualifications

• Typically requires a Bachelor's degree in Computer Science, Information Systems or related discipline and nine or more years progressive experience in database administration. May substitute equivalent working experience in the field.
• Must have a complete understanding of underlying data and applications.
• Must possess the following, including but not limited to system knowledge of Windows server, WSFC, Always On, Disaster Recovery, thorough knowledge of SQL Server databases, architecture and software development methodologies and practices; strong database performance tuning skills; and strong database troubleshooting and problem resolution skills.
• Must have the capability to perform assignments with little or no direction.
• Required to utilize independent judgment related to processing functions and activities.
• Must have analytical ability to perform moderately complex assignments, utilizing considerable judgment in order to resolve assignments in a creative and efficient manner.
• Must be computer literate with an adaptable knowledge of computer application pertinent to the position. Must be able to work independently or on a team providing solutions to a range of problems and be able to work extended hours as required.
• Must possess strong interpersonal skills, and verbal and written communication skills to interface with various levels of employees.
• Experience with Database Administration for MSSQL Server.
• Experience in troubleshooting and resolving database problems. Experience in 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 MSSQL Server - Always On , Clustering, Failover etc.
• Experience with Microsoft Azure and Cloud Solutions - IaaS, PaaS desirable
• Experience in implementing operational automation using scripts.
• Knowledge of indexes, index management, and statistics.
• Experience working with Windows server, including Active Directory and proper disk configurations.
• Good communication and documentation skills.
• Demonstrated Experience with Visual Studio .Net ASP experience.
• Demonstrated Experience with Web Application Development - HTML, XHTML, XML
• Demonstrated Experience of with .Net Framework and application development with C#, ASP, VB etc.

Preferred candidates would also meet the following criteria:

• Involvement with the MSSQL Server Community; membership in PASS, active in forums or newsgroups.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.