SQL Server DBA

SQL Server Database Administrator

San Diego, CA

Salary Range: $65,000 - $115,000

Company Overview:

Cornerstone Defense is the Employer of Choice within the Intelligence, Defense, and Space communities of the U.S. Government. Realizing early on that our most prized assets are our employees, we continually focus our attention on improving the overall work/life experience they have supporting the mission. Our Team is pushed every day to use their industry leading knowledge to provide end-to-end solutions to combat our nation’s toughest and most secure problems. If you are looking for a place to not only be professionally challenged, but encouraged and supported by a company that cares, don’t look any further than Cornerstone Defense.

Job Responsibilities:

• Administer and manage Microsoft SQL databases; administer and manage software programs; design and develop DBA components.
• Develop and enhance / modify reporting infrastructure – to provide custom and adhoc reports to various business units across the enterprise.
• 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 Buyer. 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) daily 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.
• Perform other duties as assigned.

Required Skills:

• Typically requires a bachelor’s degree in computer science, Information Systems or related discipline and five 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; 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.
• Demonstrated Experience with .Net Framework and application development with C#, ASP, VB etc.
• 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 servers, including Active Directory and proper disk configurations.
• Good communication and documentation skills.

Desired Skills:

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

Company Benefits:

Cornerstone Defense offers a comprehensive list of benefits, designed to give employees and their families several options to choose from when selecting benefits that best fit their needs. These offerings include not only a full suite of the traditional Medical/Dental/Vision insurances, but also a number of other benefits and perks to include, but not limited to: A 401(K) plan with a company match, tuition and training assistances, paid vacation/leave, a fitness reimbursement program, college savings plan, commuter benefits, financial advisory services, flex spending accounts, health savings accounts, STD/LTD coverage, life and AD&D insurance, employee assistance programs, life financial planning assistance, and legal resources.