Job Description :
Sr. Database Administrator for Georgia department of Public health
Duration: 12+Months
Location; Atlanta, Ga
Position ID: 53237

*Initial background check will be performed along with the submission*

Job Summary:

Responsible for the creation, installation, security, performance tuning, maintenance, and backups of DPH database environments. Provide information technology solutions to defined standards, constraints and system requirements to manage the databases and data dictionaries of the IT enterprise in development, test and production environments.

Job Duties and Responsibilities:
Develop scripts for the creation of the physical database schema, data security and protection
Administration skills in sizing, capacity planning in large-scale enterprise environment
Design, document and build table, column, index and view definitions to storage requirements and drive space and growth accommodations
Optimize and tuning of workloads, query or package changes and optimizations to ensure and improve system performance and reliability
Ability to design, monitor, and administer databases
Determine processes that should be developed/automated to improve efficiency and reliability
Experience planning and installing Oracle RAC databases on 11g an 12g. Worked with network and storage teams to plan and create environments.
Responsible for the creation and maintenance of complex UNIX shell scripts for the administration of databases.
Strong experience on Red hat Linux and Windows enterprise server systems.
Worked with PCI projects to secure production environments.
Worked with storage teams to present storage and add storage for ASM and ACFS file systems.
Configurated TNS, VIP and SCAN listeners
Experience with partitioning and indexing, and working with large data sets.
Experience in Oracle performance tuning. Created SQL tracing and used tkprof, SQL baselines, and Grid control.
Configured and scripted RMAN backup and recovery processes. Performed point in time recovery using RMAN and flashback operations.
Strong knowledge of SQL, analytic queries, and PL/SQL.
Provided support for Oracle Enterprise Manager Grid Control and Agents for database monitoring/performance/diagnostics.
Experienced in setting up and maintaining Oracle GoldenGate bi-directional replication

Minimum Training and Experience:
Bachelor’s degree in any of the following; data management, data sciences, information technology, computer science, business administration, or related field
10 or more years of professional experience in an IT-related domain (programming, network architect, IT data management etc
Experience performing complex reporting including demonstrated skill in composing logical, detailed and analytical reports that support planning and decision making is required
Ability to perform benchmarking analysis and identification of process improvement opportunities is required.
Experience with SQL and relational databases as well as other data management systems is required.

Preferred Qualifications:
Preference will be given to applicants who in addition to meeting the minimum qualification possess the following:
Experience with high Availability 9i and 10g Real Application Clusters (RAC) databases in UNIX and LINUX environments.
Responsible for the creation and maintenance of complex UNIX shell scripts for the administration of databases.
Experience in an IT-related domain in the Publi

Below is the Link for more jobs at nLeague Services Inc:

Client : Georgia Department of Public Health