Description

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