General Atomics - San Diego, CA

posted 3 months ago

Full-time - Senior
San Diego, CA
Professional, Scientific, and Technical Services

About the position

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 a 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. This role involves developing technical solutions to moderately complex problems and performing quality control audits to ensure accuracy, completeness and proper usage of data in tables and various report tools including Business Objects, Power BI and database dictionaries. Additionally, the position may provide direction to less experienced staff. The Senior SQL Database Administrator will administer and manage Microsoft SQL databases, software programs, and design and develop DBA components. Responsibilities include database performance tuning, troubleshooting, and problem resolution, as well as installing, patching, and upgrading SQL Server Databases. The role also requires developing SQL program instructions and providing appropriate consulting, interfacing, and training for information system users. Collaboration with Business Users and Application End Users is essential to understand reporting requirements and develop innovative solutions to provide necessary reports utilizing various web interfaces and programming tools. The position also involves importing, exporting, and backing up data between different software programs as required, performing software enhancement testing prior to release for production use, and developing, maintaining, and enhancing intranet software. Furthermore, the Senior SQL Database Administrator will review and analyze database design and integration of systems, recommend enhancements and/or improvements, and develop procedures and standards relating to database management while monitoring transaction activity and utilization. Maintaining the strict confidentiality of sensitive information and observing all laws, regulations, and other applicable obligations is crucial. The role also includes tracking and resolving database-related incidents and requests, fulfilling requests and resolving incidents within SLAs, reviewing service-related reports daily to ensure service-related issues are identified and resolved, and responding effectively to database monitoring alerts and escalations. Collaboration with Application, Business, and Database teams to develop well-defined and strategic solutions to recurring problems is also expected, along with other duties as assigned or required.

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.
  • 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.

Requirements

  • Typically requires a Bachelor's degree in Computer Science, Information Systems or related discipline and nine or more years progressive experience in database administration.
  • Must have a complete understanding of underlying data and applications.
  • Must possess 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 are essential.
  • 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.

Nice-to-haves

  • Involvement with the MSSQL Server Community; membership in PASS, active in forums or newsgroups.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service