SQL Server DBA

Calance; San Diego (CA); On-site; USD 110,000 - 170,000; Full time

Job summary

Calance is seeking a skilled SQL Database Administrator in San Diego, CA to administer MS SQL databases, develop reporting capabilities, and ensure high availability. The role covers performance tuning, backups, patching, and collaboration with business units to deliver accurate, timely reports via various interfaces and tools. Training and guidance for users are included as part of the responsibilities.

Responsibilities

• Administer and manage Microsoft SQL databases and related software applications.
• Develop and enhance reporting infrastructure to deliver custom and ad hoc reports.
• Tune database performance, troubleshoot issues, and resolve incidents.
• Install, patch, and upgrade SQL Server instances and implement best practices.
• Provide consulting, interfacing, and user training on information systems.
• Collaborate with business users to define reporting requirements and build solutions.
• Handle data import/export and data backups across different software programs.
• Test software enhancements prior to production releases.
• Develop and maintain intranet software supporting internal processes.
• Review database design and integration to identify improvements.
• Establish procedures and standards for database management and monitoring.
• Monitor SLA adherence and resolve incidents within agreed timeframes.
• Maintain confidentiality of sensitive information.
• Respond to database monitoring alerts and escalate where necessary.

Job description

1. Administer and manage Microsoft SQL databases; administer and manage software programs; design and

2. Develop and enhance / modify reporting infrastructure – to provide custom and adhoc reports to various business

units across the enterprise.

3. Database performance tuning, troubleshooting and problem resolution.

4. Install, patch, and upgrade SQL Server Databases; develop SQL program instructions.

5. Provide appropriate consulting, interfacing and training for information system users.

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

7. Import, export and back-up data between different software programs as required.

8. Perform software enhancement testing prior to release for production use.

9. Develop, maintain and enhance intranet software.

10. Review and analyze database design and integration of systems, recommend enhancements and/or

improvements.

11. Develop procedures and standards relating to database management, and monitor transaction activity and

12. Maintain the strict confidentiality of sensitive information.

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

14. Tracking and resolving database related incidents and requests

15. Fulfilling requests and resolving incidents within SLAs,

16. Reviewing service-related reports (e.g.: database backups, maintenance, monitoring) daily to ensure servicerelated

issues are identified and resolved within established SLAs

17. Responding effectively to database monitoring alerts and escalations

18. Collaborate with Application, Business and Database teams to come up with well-defined and strategic solutions