Find Jobs Find Talent
SQL DBA Administrator
McKinney,  |  Hybrid, Onsite
Direct Hire Position
It appears that you have already applied to this job.
Applied on May 24, 2022
Job Id #55888 Posted April 22, 2022

Job Description
The Database Administrator II (DBA II) will be a part of the client's Data Architecture team, performing both database administration, ETL, and data migrations. The primary responsibility of this role will be managing, maintaining, and providing ongoing production support of existing company databases.

DUTIES AND RESPONSIBILITIES 
• Provide database administration support for various on-prem SQL Servers, Azure SQL Databases, and other database environments hosting critical applications.
• Perform administration tasks in development, QA, and production database environments, as well as performing SQL development tasks for automation.
• Develop and support ETL solutions between both internal and external systems, which requires active participation in refactoring efforts with the goal of making the ETL processes more stable and performant.
• Collaborate with support teams to troubleshoot and resolve issues with the ETL processes.
• Play a proactive role in current database/ETL operations, recommending best practices to supervisor in order to improve operations, as needed.
• Manage SQL Server databases through multiple lifecycle environments, from development to mission-critical production systems.
• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security (roles and permissions).
• Conduct database upgrades, automation, migration, patching, replication, capacity planning, script development.

ADDITIONAL DUTIES AND RESONSIBILITIES
• Completes all required compliance exams on a yearly basis.
• Travel up to 10% of the time, possible.

Required Knowledge & Abilities:
• Database Lifecycle Management (DLM)
• Strong design theories, database architecture, database management & security best practices knowledge.
• Data warehousing (Dimensional Modeling, ETL etc.) and RDBMS concepts

Skill in:
• Database administration of SQL server databases with proactive approaches.
• Install, maintain, develop optimized databases.
• Strong Command of SQL, stored procedures, and triggers
• SSIS, SQL job configuration and API extraction methods
• Advanced working experience in SQL Query optimization and ETL tools, such as SSIS
• Shell scripting (working experience)
• SQL performance tuning and interpreting traces (proficient)

Ability to:
• Work in fast-paced fluid environment with minimum supervision
• Monitor alerts and job failures; efficiently and accurately remediate or escalate such failures as required
• Interpreting data traffic from applications
• Own the production environment with responsibility being 24/7

Preferred Qualifications
• Certification in SQL server administration and Azure cloud database administration.
• Experience in SQL Server analytical stack such as SSAS, SSRS in building data models and configuration of reporting platforms.
• Advanced programming experience.
• Working experience in SSAS multidimensional/tabular data model.
• Experience deploying machine learning models and automating processes in production.
• Experience with cloud technologies (AWS, Azure).
• Hands on experience in either one of the leading BI tools like Tableau, Power BI etc.

Education and Work Experience 
• Bachelor’s degree in Computer Science or related degree is required.

Horizontal is proud to be an Equal Opportunity and Affirmative Action Employer. We seek to provide employment opportunities to talented, qualified candidates regardless of race, color, sex/gender including gender identity and/or expression, national origin, religion, sexual orientation, disability, marital status, citizen status, veteran status, or any other protected classification under federal, state or local law.

In addition, Horizontal will provide reasonable accommodations for qualified individuals with disabilities. If you need to request a reasonable accommodation in order to complete the application or interview process, please contact hr@horizontal.com.

All applicants applying must be legally authorized to work in the country of employment.

EQUAL OPPORTUNITY EMPLOYMENT SURVEY

What is your gender?

What is your ethnicity?

What is your Veteran / U.S. Military Status?

Do you identify with one or more of the classifications of protected veterans below?

If yes, please indicate by checking the appropriate box below

Do you have a disability?

You are considered to have a disability if you have a physical or mental impairment or medical condition that substantially limits a major life activity, or if you have a history or record of such an impairment or medical condition.

Horizontal is proud to be an Equal Employment Opportunity/Affirmative Action Employer providing a drug-free workplace.

Success!

You have saved your first job! To see all your Saved Jobs, click here. Or continue scrolling through jobs and bookmark openings that catch your eye and apply for those jobs later.

Return to Job Search
Close

We’re sorry!

There are currently no open positions in your location or accepting applications from out of the country

Return to Home
Close
X
Cookies help us improve your website experience.
By using our website, you agree to our use of cookies.
Confirm