• Find preferred job with Jobstinger
  • ID
    #10480441
  • Job type
    Permanent
  • Salary
    USD Depends on Experience Depends on Experience
  • Source
    AbleForce
  • Date
    2021-03-02
  • Deadline
    2021-05-01

SQL DBA

California, San diego, 92121 San diego USA
 
Permanent

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