Job Description

Duration: 12 Months

Responsibilities

• The Administers Database position is responsible for backup, recovery, server architecture, performance tuning, security, auditing, metadata management, optimization, statistics, capacity planning, connectivity, and other data solutions of mission critical database systems.
• Develops databases with SQL, stored procedures, triggers, transactional modeling, dimensional modeling, normalization, indexing methods, constraints, and object usage.
• Builds and maintains the ongoing operational functionality and efficiency of CPS Energy databases ensuring system performance, availability, reliability, security, recoverability, and efficient usage of server infrastructure resources.
• Performs the capacity planning required to create and maintain corporate databases and processing demands.
• Ensures database system security, change management, backup and recovery are maintained in compliance with corporate, state, and federal regulations.
• Provides database solutions to solve complex business issues including data processing, loading, performance improvements, data storage and data replication.
• Diagnoses, troubleshoots, and resolves database related issues including storage, performance, availability, data integrity and database security.
• Performs and automates database management, maintenance, and data processing activities.
• Applies understanding of modern networks and operating systems as they pertain to database system architecture and functionality.
• Develops scripts to perform system maintenance, monitor systems, automate tasks, etc.
• Performs as technology subject matter expert for relational database management systems such as Oracle 10g, 11g, 12c, 18c and 19c.

Qualifications & Experience

• Bachelor's degree (or higher), or foreign degree equivalent, in Information Systems, Engineering, Computer Science or related field.
• A minimum of six years’ experience in a Production Oracle ecosystem or higher education equivalent.
• Hands on experience with Oracle database administration in UNIX and virtual environments.
• Skilled in performing detailed performance analysis and resource utilization of systems.
• Proficiency with Oracle backups, restores and recovery models.
• Hands on experience with High Availability (HA) and Disaster Recovery (DR) options for Oracle (RAC/Data Guard).
• Know-how in migrating code and database changes through the various stages of the development life cycle.
• Skilled in troubleshooting and performance tuning skills with Oracle databases.
• Experience in project management concepts, tools (MS Project) and techniques.
• Hands on experience as technology subject matter expert for at least three versions of relational database management systems such as Oracle 9i, 10g, 11g, 12c, 18c and 19c.
• Installation, configuration, and administration of Oracle Golden Gate replication that includes troubleshooting of extracts, pump, and replication processes.

Skills

• ERP experience
• Oracle Administration
• SQL

About US Tech Solutions:

US Tech Solutions is a global staff augmentation firm providing a wide range of talent on-demand and total workforce solutions. To know more about US Tech Solutions, please visit .

US Tech Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, colour, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Recruiter Details:

Name: P Praveen Chary

Email: praveenc@ustechsolutions.com

Internal Id: 25-40146

Job Tags

Similar Jobs