Job Description :
Sr. SQL DBA with Oracle DBA Exp.
Location: Houston, TX
Duration: 6-12 Months
Education & Experience:
10+ years of experience with SQL Server and SQL Server Database Administrator for versions 2000, 2005, 2008R2, 2012
3+ years professional experience as an Oracle Database Administrator for versions 11g & 12c as well as MSSQL 2012.
In addition the candidate must have Windows 4+ years of Windows experience.
Job Responsibilities:
* Will be expected to support a SQL Server environment of 1500+ databases as one of three primary database administrators and provide secondary support role for Oracle database environment of 450+ databases.
1. Maintenance
a. Backup & Recovery
2. Testing
a. Alerts (Job failures, database & server capacity, etc…)
b. Database integrity checks
c. Review logs
d. Updates database statistics
3. Administering High Availability solutions
a. Windows Clusters (SQL Server)
b. Standby databases & log shipping (SQL Server)
c. Data Guard (Oracle)
4. Troubleshooting databases performance issues
5. Troubleshooting application performance issues
6. Database Maintenance & Configuration
a. Patching
b. Upgrading
7. Security
a. Auditing
b. Configuring
c. Documenting
8. Application (DDL & DML)
a. Enhancement & Corrective Changes
b. Emergency Changes
c. Patching
d. Upgrading
9. Process Improvements
10. SOX Control management & reporting
11. Participate in the DBA On-call 1 week a month
12. Documenting environments and processes where applicable
13. Work with other DBA team members
14. Work with various application teams
Candidates must have the following SQL Server skills:
Advanced knowledge in SQL Server database administrator functions, including performance tuning, DB backup and recovery, capacity planning, replication, high availability (Cluster Management), monitoring or custom scripts, installing & upgrading RDBMS S/W and of databases
Candidates must have 3 or more of the following Oracle skills:
Advanced knowledge in Oracle database administrator functions, including performance tuning, DB backup and recovery (RMAN), capacity planning, replication, high availability (Data Guard), monitoring using Grid Control or custom scripts, installing & upgrading RDBMS S/W and databases
Good understanding and working knowledge of SQL, PLSQL and triggers and proficient knowledge or certification in a MS Windows environment
A Plus:
UNIX operating system environment, including scripting for automation of database tasks
The following professional and personal skills are required in a candidate:
Must be decisive, focus on priorities, demonstrate high engagement levels and communicate upwards with no surprises
Advanced problem-solving and analytical skills, able to determine the impact of an issue quickly to prioritize further work
Able to contribute to operational debates, helping to identify and address future opportunities and challenges
Able to manage and prioritize day to day workload to ensure maximum efficiencies are gained
Promotes a positive and professional work environment with drive and enthusiasm. Candidate must be self-motivated and be able to work independently
Able to manage successful relationships, can influence stakeholders and shares knowledge effectively
Must possess strong communication skills (both written and oral) and good one-on-one interpersonal skills
Understands and has a commitment to the philosophy, mission, values, and vision of CLIENT Group
Must have strong skills in detail orientation, teamwork, remote working in a global setting, and strong follow-through
Will be expected to support the Production database environment of both Oracle and SQL Server in a 24/7, on-call capacity as needed
Looking forward for your response.