SQL Database Administrator- Columbus, OH

Georgia Tek Systems

Columbus, OH
7 days ago

Want to know if you’re a fit?
Upload your resume and let our AI show you.

Skills

Administrative Skillsunmatched
Amazon Elastic Compute Cloud (EC2)unmatched
Amazon Relational Database Service (RDS)unmatched
Amazon Web Services (AWS)unmatched
Change Controlunmatched
Communication Skillsunmatched
Computer Serversunmatched
Data Recoveryunmatched
Database Administrationunmatched
Database Extract Transform and Load (ETL)unmatched
Database Management Software/Systems (DBMS)unmatched
Database Optimizationunmatched
Database Replicationunmatched
Database Technologyunmatched
Database Triggersunmatched
Enterprise Protectionunmatched
Establish Prioritiesunmatched
Help Deskunmatched
High Availabilityunmatched
Identify Issuesunmatched
Information/Data Security (InfoSec)unmatched
Mentoringunmatched
Microsoft SQL Serverunmatched
Microsoft Transact-SQL (T-SQL)unmatched
Microsoft Windows Operating Systemunmatched
Microsoft Windows Serverunmatched
MongoDBunmatched
Multitaskingunmatched
MySQLunmatched
Network Operations Centerunmatched
NoSQLunmatched
On Callunmatched
Oracleunmatched
Performance Managementunmatched
Performance Testingunmatched
Performance Tuning/Optimizationunmatched
PostgreSQLunmatched
Presentation/Verbal Skillsunmatched
Problem Solving Skillsunmatched
SQL (Structured Query Language)unmatched
SQL Databasesunmatched
SQL Server Integration Services (SSIS)unmatched
Scripting (Scripting Languages)unmatched
Security Monitoringunmatched
Service Deliveryunmatched
Software Configuration Managementunmatched
Software Installationunmatched
Software Patchesunmatched
Software Upgradesunmatched
Source Code/Configuration Management (SCM)unmatched
Statisticsunmatched
Stored Proceduresunmatched
Strategic Planningunmatched
Systems Administration/Managementunmatched
Vendor/Supplier Selectionunmatched
Windows PowerShellunmatched
Writing Skillsunmatched

Description

Position- SQL Database Administrator
Location- Columbus, OH

Essential Activities and Responsibilities:

Function as a Production and a Development Database Administrator.
As a Database Administrator, performs specialized technical job functions with limited instruction while relying on experience and broad judgement to deliver services and accomplish goals. Participates in strategic planning for major upgrades and implementations while following the internal standards and guidelines. Provides capacity and growth planning as per the business needs.
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 clusters, 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.
Adheres to standard protocols in ensuring that security and integrity of the database environments are maintained. Defines, implements, and manages security roles and permissions for all applications, modules and database users.
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 and testing 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.
Participates in team on-call rotation; shares knowledge and provides mentorship and support to other database administrators. Carries out other duties as assigned by management.

Knowledge, Skills, & Abilities:

Overall 10+ years of managing SQL Server environments with minimum 5-7 years' experience in SQL server 2014 or later in an administrative role.
Must possess high-level of proficiency in SQL, T-SQL and Powershell.
Must possess 3+ years of experience building, deploying and maintaining ETL packages using SSIS.
Must possess experience installing, configuring, upgrading database software including HADR configurations.
3-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/2019)
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.
Ability to document and communicate effectively with the team regarding technical, progress and critical issues. Possess excellent written and verbal communication skills.
Ability to handle multiple projects at one time.

Numbers & Facts

Location

Columbus, OH

Resume Resources

Free Resume Templates Free Resume Builder