Administrator Database Oracle from Innova Solutions
San Antonio, TX 78215
About the Job
Innova Solutions is immediately hiring an Administrator Database Oracle.
Position type: Full-time- Contract
Duration: 12+ Months
Location: San Antonio, TX, 78215
As a Administrator Database Oracle, you will:
Job Description:
The Database Administrator 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.
The ideal candidate will have:
• Builds and maintains the ongoing operational functionality and efficiency of 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.
• Modifies existing databases and database management systems or directs programmers and analysts to make changes with appropriate database objects such as indexes, tables, partitions, triggers, constraints, stored procedures, large objects, views, etc.
• Works as part of a project team to coordinate database development and determine project scope and limitations.
• Writes and codes logical and physical database descriptions and specifies identifiers of database to management system or directs others in coding descriptions.
• Reviews project requests describing database user needs to estimate time and cost required to accomplish project.
• Develops standards and guidelines to guide the use and acquisition of software and to protect vulnerable information.
• Administers all database objects, including tables, clusters, indexes, views and sequences, packages and procedures.
• Evaluates releases of Oracle and its tools, and third-party products to ensure that the organization is running the products that are most appropriate.
• Troubleshoots issues associated with databases, applications and development tools and provides technical support to application development teams.
• On-call rotation is required to support 24/7 environment and is also expected to be able to work outside business hours to support corporate needs.
• Installs, configures, and administers Oracle Golden Gate replication that includes troubleshooting of extracts, pump, and replication processes.
• Uses Commvault to perform database backups, point-in-time restore and recoveries.
• Applies OEM (Oracle Enterprise Manager) for troubleshooting database performance tuning and generating reports using Information Publisher and BI Publisher reports.
• Collaboration with various technical/non-technical resources such as infrastructure and application teams regarding project work, POCs (Proofs of Concept) and/or troubleshooting exercises.
• Analyzes Operating System statistics and troubleshooting performance related problems on storage, I/O (Input/Output) throughput and OS (Operating System) kernel parameters.
• Upgrades Oracle databases using logical standby to minimize downtime to applications.
• Creation and configuration of Oracle Data Guard to use physical, logical, snapshot standby databases, and Fast Start Failover.
• Performs Unix (AIX) and Linux operating systems tasks associated with Oracle.
• Creation and configuration of Oracle Multitenant database environments.
Essentials:
• 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.
• OEM (Oracle Enterprise Manager) troubleshooting of database performance tuning and generating reports using Information Publisher and BI Publisher reports.
• Skilled in using Recovery Manager (RMAN) and ASM (Automatic Storage Management) for backups and storage management.
• Strong ability to organize information, manage tasks and use available tools to effectively contribute to a team and the organization.
• Valid Class C Texas Driver’s License.
• Proficient in Microsoft Office Package, including word processing, spreadsheets, presentation software, electronic mail and scheduling.
Qualified candidates should APPLY NOW for immediate consideration! Please hit APPLY to provide the required information, and we will be back in touch as soon as possible.
We are currently interviewing to fill this and other similar positions. If this role is not a fit for you, we do offer a referral bonus program for referrals that we successfully place with our clients, subject to program guidelines. ASK ME HOW.
Thank you!
Talat
Associate Recruitment
Talat.Perveen@innovasolutions.com
PAY RANGE AND BENEFITS:
Pay Range*: $50/hr - $54/hr.
*Pay range offered to a successful candidate will be based on several factors, including the candidate's education, work experience, work location, specific job duties, certifications, etc.
Benefits: Innova Solutions offers benefits( based on eligibility) that include the following: Medical & pharmacy coverage, Dental/vision insurance, 401(k), Health saving account (HSA) and Flexible spending account (FSA), Life Insurance, Pet Insurance, Short term and Long term Disability, Accident & Critical illness coverage, Pre-paid legal & ID theft protection, Sick time, and other types of paid leaves (as required by law), Employee Assistance Program (EAP).
ABOUT INNOVA SOLUTIONS: Founded in 1998 and headquartered in Atlanta, Georgia, Innova Solutions employs approximately 50,000 professionals worldwide and reports an annual revenue approaching $3 Billion. Through our global delivery centers across North America, Asia, and Europe, we deliver strategic technology and business transformation solutions to our clients, enabling them to operate as leaders within their fields.
Recent Recognitions:
• One of Largest IT Consulting Staffing firms in the USA – Recognized as #4 by Staffing Industry Analysts (SIA 2022)
• Clearly Rated® Client Diamond Award Winner (2020)
• One of the Largest Certified MBE Companies in the NMSDC Network (2022)
• Advanced Tier Services partner with AWS and Gold with MS
Website: https://www.innovasolutions.com/
Innova Solutions is an Equal Opportunity Employer and prohibits any kind of unlawful discrimination and harassment. Innova Solutions is committed to the principle of equal employment opportunity for all employees and to providing employees with a work environment free of discrimination and harassment on the basis of race, color, religion or belief, national origin, citizenship, social or ethnic origin, sex, age, physical or mental disability, veteran status, marital status, domestic partner status, sexual orientation, or any other status protected by the statutes, rules, and regulations in the locations where it operates. If you are an individual with a disability and need a reasonable accommodation to assist with your job search or application for employment, please contact us at hr@innovasolutions.com or (770) 493-5588. Please indicate the specifics of the assistance needed. Innova Solutions encourages all interested and qualified candidates to apply for employment opportunities. Innova Solutions (HireGenics/Volt) does not discriminate against applicants based on citizenship status, immigration status, or national origin, in accordance with 8 U.S.C. § 1324b.
The company will consider for employment qualified applicants with arrest and conviction records in a manner that complies with the San Francisco Fair Chance Ordinance, the Los Angeles Fair Chance Initiative for Hiring Ordinance, and other applicable laws.
Position type: Full-time- Contract
Duration: 12+ Months
Location: San Antonio, TX, 78215
As a Administrator Database Oracle, you will:
Job Description:
The Database Administrator 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.
The ideal candidate will have:
• Builds and maintains the ongoing operational functionality and efficiency of 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.
• Modifies existing databases and database management systems or directs programmers and analysts to make changes with appropriate database objects such as indexes, tables, partitions, triggers, constraints, stored procedures, large objects, views, etc.
• Works as part of a project team to coordinate database development and determine project scope and limitations.
• Writes and codes logical and physical database descriptions and specifies identifiers of database to management system or directs others in coding descriptions.
• Reviews project requests describing database user needs to estimate time and cost required to accomplish project.
• Develops standards and guidelines to guide the use and acquisition of software and to protect vulnerable information.
• Administers all database objects, including tables, clusters, indexes, views and sequences, packages and procedures.
• Evaluates releases of Oracle and its tools, and third-party products to ensure that the organization is running the products that are most appropriate.
• Troubleshoots issues associated with databases, applications and development tools and provides technical support to application development teams.
• On-call rotation is required to support 24/7 environment and is also expected to be able to work outside business hours to support corporate needs.
• Installs, configures, and administers Oracle Golden Gate replication that includes troubleshooting of extracts, pump, and replication processes.
• Uses Commvault to perform database backups, point-in-time restore and recoveries.
• Applies OEM (Oracle Enterprise Manager) for troubleshooting database performance tuning and generating reports using Information Publisher and BI Publisher reports.
• Collaboration with various technical/non-technical resources such as infrastructure and application teams regarding project work, POCs (Proofs of Concept) and/or troubleshooting exercises.
• Analyzes Operating System statistics and troubleshooting performance related problems on storage, I/O (Input/Output) throughput and OS (Operating System) kernel parameters.
• Upgrades Oracle databases using logical standby to minimize downtime to applications.
• Creation and configuration of Oracle Data Guard to use physical, logical, snapshot standby databases, and Fast Start Failover.
• Performs Unix (AIX) and Linux operating systems tasks associated with Oracle.
• Creation and configuration of Oracle Multitenant database environments.
Essentials:
• 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.
• OEM (Oracle Enterprise Manager) troubleshooting of database performance tuning and generating reports using Information Publisher and BI Publisher reports.
• Skilled in using Recovery Manager (RMAN) and ASM (Automatic Storage Management) for backups and storage management.
• Strong ability to organize information, manage tasks and use available tools to effectively contribute to a team and the organization.
• Valid Class C Texas Driver’s License.
• Proficient in Microsoft Office Package, including word processing, spreadsheets, presentation software, electronic mail and scheduling.
Qualified candidates should APPLY NOW for immediate consideration! Please hit APPLY to provide the required information, and we will be back in touch as soon as possible.
We are currently interviewing to fill this and other similar positions. If this role is not a fit for you, we do offer a referral bonus program for referrals that we successfully place with our clients, subject to program guidelines. ASK ME HOW.
Thank you!
Talat
Associate Recruitment
Talat.Perveen@innovasolutions.com
PAY RANGE AND BENEFITS:
Pay Range*: $50/hr - $54/hr.
*Pay range offered to a successful candidate will be based on several factors, including the candidate's education, work experience, work location, specific job duties, certifications, etc.
Benefits: Innova Solutions offers benefits( based on eligibility) that include the following: Medical & pharmacy coverage, Dental/vision insurance, 401(k), Health saving account (HSA) and Flexible spending account (FSA), Life Insurance, Pet Insurance, Short term and Long term Disability, Accident & Critical illness coverage, Pre-paid legal & ID theft protection, Sick time, and other types of paid leaves (as required by law), Employee Assistance Program (EAP).
ABOUT INNOVA SOLUTIONS: Founded in 1998 and headquartered in Atlanta, Georgia, Innova Solutions employs approximately 50,000 professionals worldwide and reports an annual revenue approaching $3 Billion. Through our global delivery centers across North America, Asia, and Europe, we deliver strategic technology and business transformation solutions to our clients, enabling them to operate as leaders within their fields.
Recent Recognitions:
• One of Largest IT Consulting Staffing firms in the USA – Recognized as #4 by Staffing Industry Analysts (SIA 2022)
• Clearly Rated® Client Diamond Award Winner (2020)
• One of the Largest Certified MBE Companies in the NMSDC Network (2022)
• Advanced Tier Services partner with AWS and Gold with MS
Website: https://www.innovasolutions.com/
Innova Solutions is an Equal Opportunity Employer and prohibits any kind of unlawful discrimination and harassment. Innova Solutions is committed to the principle of equal employment opportunity for all employees and to providing employees with a work environment free of discrimination and harassment on the basis of race, color, religion or belief, national origin, citizenship, social or ethnic origin, sex, age, physical or mental disability, veteran status, marital status, domestic partner status, sexual orientation, or any other status protected by the statutes, rules, and regulations in the locations where it operates. If you are an individual with a disability and need a reasonable accommodation to assist with your job search or application for employment, please contact us at hr@innovasolutions.com or (770) 493-5588. Please indicate the specifics of the assistance needed. Innova Solutions encourages all interested and qualified candidates to apply for employment opportunities. Innova Solutions (HireGenics/Volt) does not discriminate against applicants based on citizenship status, immigration status, or national origin, in accordance with 8 U.S.C. § 1324b.
The company will consider for employment qualified applicants with arrest and conviction records in a manner that complies with the San Francisco Fair Chance Ordinance, the Los Angeles Fair Chance Initiative for Hiring Ordinance, and other applicable laws.