02 Mar
SQL DBA
California, San diego , 92121 San diego USA

Please, no third parties.This will be onsite in San Diego, CA after COVID and there is no relocation assistance available.

Main Duties and Responsibilities:- Troubleshoot day-to-day database and application issues- Play an integral role with the documentation of existing systems and configurations- Assist with design, implementation and support of standards and procedures for monitoring, capacity planning, maintenance, backups and recovery- Support multiple databases in development, staging and production environments in local and remote data centers- Configure and support high-availability for SQL Server including replication and mirroring - Support application teams and resolve database problems- Install server-based applications software in coordination with system administrators- Install and manage new software, upgrades and patches- Create and implement best practices for stored procedures, triggers, packages, tables and views- Optimize database performance by analyzing and tuning stored procedures, creating indexes and views, etc. as needed- Configure and maintain enterprise ETL processes using various ETL tools, including SSIS, .NET scripting, and T-SQL- Complete database maintenance procedures and generate system reports- Create and implement security models- Participate in application development processes to facilitate good database design and access techniques- Plan, prepare and test backup and recovery procedures for all production databases- Monitor databases for efficiency and periodically reorganize databases for optimal performance during scheduled downtime- Create indices and manipulate tuning parameters where needed to enhance performance- Calculate volumetric equations to estimate new database sizes and plan appropriately for growth- Communicate plans to system administrators- Responsible for the security of database systems and all business/scientific applications connected to it, including creating and maintaining database and application accounts, application/database patching, and database/application security auditing- Product monitoring for performance and health, participate in load test activities

Skills and Requirements:- 5+ years of experience with MS SQL in enterprise, multi-site SQL Server Database environments- Merge Replication- Mirroring- Azure DBA experience highly preferred – currently moving to this environment- Effective written and oral communication skills, as well as organizational and interpersonal skills- Willingness and proven ability to provide the highest level of customer service- SSRS, SSAS and/or SSIS experience is a plus tags: sql dba, sql database administrator, sql database engineer, database developer, sql developer, database admin


Report job