General Atomics and Affiliated Companies
Senior SQL Database Administrator
General Atomics and Affiliated Companies, San Diego, California, United States, 92189
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.
46170
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.
Salary: $98,100 - $171,398 Travel Percentage Required 0 - 25 Relocation Assistance Provided Provided US Citizenship Required? Yes Clearance Required? No Clearance Level null Workstyle Hybrid
General Atomics is committed to hiring and retaining a diverse workforce. We are an Equal Opportunity/Affirmative Action Employer and will consider all qualified applicants for employment without regard to race, color, religion, religious creed, ancestry, gender, pregnancy, sex, sexual orientation, transitioning status, gender identity, gender expression, national origin, age, genetic information, military and veteran status, marital status, medical condition, mental disability, physical disability, or any other basis protected by local, state, or federal law. EEO is the law. We also prohibit compensation discrimination under all applicable laws. To learn more visit https://tbcdn.talentbrew.com/company/499/v2_0/EEO Notices.pdf. U.S. Citizenship is required for certain positions.
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.
46170
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.
Salary: $98,100 - $171,398 Travel Percentage Required 0 - 25 Relocation Assistance Provided Provided US Citizenship Required? Yes Clearance Required? No Clearance Level null Workstyle Hybrid
General Atomics is committed to hiring and retaining a diverse workforce. We are an Equal Opportunity/Affirmative Action Employer and will consider all qualified applicants for employment without regard to race, color, religion, religious creed, ancestry, gender, pregnancy, sex, sexual orientation, transitioning status, gender identity, gender expression, national origin, age, genetic information, military and veteran status, marital status, medical condition, mental disability, physical disability, or any other basis protected by local, state, or federal law. EEO is the law. We also prohibit compensation discrimination under all applicable laws. To learn more visit https://tbcdn.talentbrew.com/company/499/v2_0/EEO Notices.pdf. U.S. Citizenship is required for certain positions.