SQL Server DBA: Performance, HA & Automation

Calance; San Diego (CA); On-site; USD 90,000 - 130,000; Full time

Job summary

Calance seeks an experienced SQL Server DBA to administer and optimize Microsoft SQL databases across the enterprise. You will design structures, tune performance, implement HA/DR, and drive data integration and reporting improvements.

You will collaborate with business units and IT teams to deliver robust solutions, develop scripts, and ensure security and compliance in a dynamic environment.

Qualifications

• Administer and manage Microsoft SQL databases.
• Develop and enhance reporting infrastructure to provide custom and ad hoc reports across the enterprise.
• Perform database performance tuning and troubleshooting.
• Install, patch, and upgrade SQL Server databases; develop SQL program instructions.
• Provide consulting, interfacing and training for information system users.

Responsibilities

• Administer and manage Microsoft SQL databases; administer and manage software programs; design and
• 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
• 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.
• 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 servicerelated 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

Skills

SQL Server administration

Database design

Performance tuning

Backup & recovery

High availability

SQL scripting

Data integration

BI reporting

Power BI

Reporting tools

Azure cloud

.NET development

Tools

Windows Server

Active Directory

SQL Server Management Studio

Power BI

Business Objects

Job description

Calance seeks an experienced SQL Server DBA to administer and optimize Microsoft SQL databases across the enterprise. You will design structures, tune performance, implement HA/DR, and drive data integration and reporting improvements.

You will collaborate with business units and IT teams to deliver robust solutions, develop scripts, and ensure security and compliance in a dynamic environment.