Database Administrator

Prabhav Services Inc.; Dallas (TX); On-site; USD 80,000 - 110,000; Full time

Job summary

Prabhav Services Inc. in Dallas, TX, is seeking a Database Administrator to support the corporate database environment within the Infrastructure group.

The role emphasizes setup and management of SQL Server maintenance plans, performance monitoring, and database design and administration. Responsibilities include monitoring SQL performance, daily jobs, backups/restores, and collaborating with web and report developers.

Qualifications

• 1 year of DBA-like tasks experience.
• 2+ years of broad IT experience.
• On-call availability as needed.
• Strong documentation and communication skills.

Responsibilities

• Establish and monitor SQL database maintenance plans.
• Monitor SQL performance data.
• Monitor daily scheduled SQL jobs and packages.
• Support requests for unscheduled database backups and restores.
• Collaborate with web and report developers.
• Manage database-related release activities for staging and production systems.
• Develop, configure and maintain databases and related systems; write SQL queries, views, jobs and stored procedures.
• Adhere to policies, processes and procedures within responsibilities.

Skills

SQL

Database administration

Performance monitoring

Documentation

On-call support

Team collaboration

Tools

SQL Server

Backups & Restores

RDBMS concepts

Job description

Job Role: Database Administrator

Location: Dallas ,TX

Duration: 8-12+ Months (Possible Extension)

Position: Onsite / W2

Responsibilities

Prabhav Services is seeking a Database Administrator to provide support for the corporate database environment within the Infrastructure group. The individual shall be a self-starter, highly motivated and able to work in a fast-paced environment under pressure. This position will be responsible for handling various tasks including but not limited to setup and management of SQL server maintenance plans, monitoring of SQL performance, database design and administration. This position does not require travel.

Job Responsibilities

• Establishment and monitoring of SQL database Maintenance Plans
• Monitoring of SQL performance data
• Monitoring status and results of daily scheduled SQL jobs and packages
• Support requests for unscheduled Database backups and restores
• Working closely with web and report developers
• Managing database-related release activities for staging and production systems
• Developing, configuring and maintaining databases and related systems. This includes writing well-formed, efficient SQL queries, views, jobs and stored procedures
• Adherence to policies, processes and procedures within your areas of responsibility

Qualifications

Talent Requirements

• Highly organized and detail-oriented
• Excellent documentation, communication and interpersonal skills
• Excellent analytical and problem-solving abilities
• One (1) year experience performing DBA like tasks
• Two (2)+ years of broad-based IT experience

Desired Qualifications

• Experience with SQL Language (SELECT, INSERT, UPDATE, DELETE)
• Familiarity with backups and restores including differential and transaction logs
• Experience with RDBMS - Primary Keys, Foreign Keys, Indexing
• Unique Records/Duplication
• Knowledge of transactions - Understand ACID Properties
• Basic data modeling skills
• Ability to provide on-call support outside normal business hours as needed