SQL DBA

SQL DBA

Remote

Long Term

Exp: 10+

Core Skills:

• Min 10+ years' experience in SQL server 2012 or later in an administrative role.
• Must possess high-level of proficiency in SQL and T-SQL.
• Must possess 3+ years of experience building, deploying and maintaining ETL packages using SSIS.
• Must possess experience installing, configuring, and upgrading database software including HADR configurations.
• 5 years' experience creating/updating/optimizing/troubleshooting - Stored procedures/functions, tables, views, triggers, indexes and constraints. Experience with database object migrations across multiple database environments and keeping various environments in sync.
• Must possess experience in troubleshooting and resolving job failures, performance issues, blocking/deadlocking issues, connectivity and security issues.
• Proficient in optimizing database workloads using Profiler/Extended Events/DMV's or other database monitoring tools. Experience with Solarwinds DPA is preferable.
• Possess Good working knowledge of windows server operating systems (2012/2016)
• Possess strong knowledge of backups, restores and recovery models.
• Possess solid understanding of various Amazon Web Services especially AWS RDS, EC2 and S3.
• Familiarity with other SQL/NoSQL databases such as Oracle, MySQL, PostgreSQL, MongoDB, etc. is a plus
• Experience with enterprise information security, user accounts and database security management.
• Experience with source control and change control processes and tools.
• Ability to work unsupervised, prioritize task lists and be self-responsible and accountable.
• Installs, configures, upgrades and patches custom built, as well as vendor supplied database, applications and/or third-party software. Installs and manages high-availability features such as availability groups, mirroring and database replication.
• Performs database maintenance such as index/statistics maintenance, space allocations, backups, restores and works with developers and users about data archiving/purging. Develops automation scripts and processes to streamline administrative tasks.
• Focuses on Database Availability and Uptime. Monitors database usage and performance and takes necessary actions regarding indexes, SQL statements, space allocations and server/database configurations to improve overall performance. Performs application-specific performance tuning as needed and as recommended by vendor for their specific applications.
• Consults with developers and users to define data requirements, data load needs, database standards and migration procedures. Partners with Server, Storage and Networking teams for various resource needs and to keep Database Systems functioning smoothly. Additionally, Interfaces with NOC and Help Desk teams for problem/failure resolution, and to provide information and analysis of significant production issues.