SUMMARY:
The Sr. Database Administrator is responsible for coordinating physical changes to computer databases; and codes, tests, and implements database by performing the following duties.
ESSENTIAL 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 clustering, 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
Other duties as assigned
Requirements Bachelor of Science Degree in Computer Science or related field.
Must have a strong background in client-server technology.
Must have working knowledge of SQL Server.
5+ years of experience as a SQL DBA in enterprise, multi-site SQL Server environments
Intermediate to advanced skills with SSIS and T-SQL
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
Experience with Microsoft Azure Technologies and Deploying databases into cloud environments
Reporting Services (SSRS) and Analysis Services (SSAS) experience is preferred but not required
Experience with .NET scripting (C# or VB.NET) and/or PowerShell is preferred but not required
Experience in the Automotive Industry is preferred but not required
Experience in CRM systems is preferred but not required
Strong verbal and written communication skills; ability to speak directly with both clients and vendors
Strong math and Algebra skills
Ability to problem solve and diagnose applications that work with databases
Salary Description
125-135K/year
