Oracle Dba Consultant

Oracle Dba Consultant
Company:

Hcl America Inc.


Oracle Dba Consultant

Details of the offer

Job Title : Sr. DBA (Multi Skilled ) Oracle, PostgreSQL, MySQL.
Location : Framingham, MA, US.

Responsibilities :-
Database monitoring, administration of Oracle databases.
Troubleshoot and resolve database issues, handle table space, Filesystem space issues
Perform database Upgrade and migration - Should have experience in upgrade and Migration
Knowledge to apply and troubleshoot PSU patch and related issues for standalone, RAC and Data guard setups.
Knowledge to setup/manage and troubleshoot RAC, Dataguard issues.
Interact with client/end users to understand requirements and provide relevant solution.
Handle all priority issues, P1/P2s , resolve and provide RCA.
Good knowledge in database installation using GUI/Silent mode. / database upgrade.
Administration and troubleshooting for Oracle Enterprise Manager and related agents
Document all procedures and provide cross-training for any additional DBA member in the division.
Knowledge on Golden gate end to end data flow and troubleshooting
Install, configure and maintain MySQL databases.
Ensure performance, availability, and security of clusters of MySQL instances. Orchestrating upgrades, backups, and provisioning of database instances.
Configure GTID based complex multi-master and multi-slave cluster topologies
Simulate failover and replication topology changes. , Knowledge on InnoDB clusters and other HA solutions
Good knowledge on handling databases as PaaS service on Azure Platform.
Analyze and resolve complex technical problems, including performance tuning, and application design and debugging.
Knowledge on Migration, conversion of on-prem Oracle databases to MySQL/Postgres
Administer Postgres databases on-premise as well as PaaS service
Configure and maintain Postgres master slave topology.
Knowledge on opensource utilities like pgpool, pgbouncer, repmgr, BSD.
Ability to provide full DBA support for open-source MySQL and Postgres, without vendor support.
Oversee utilization of data and log files., Manage database logins and permissions for users.
Provide production support of existing applications, DBA will need to respond quickly to critical issues and may be required to provide support after hours.
Ensure integrity, availability and performance of Oracle database systems by providing technical support and maintenance.
Monitor database performance and recommend improvements for operational efficiency.
Assist in capacity planning, space management, user/schema management and data maintenance activities for database system.
On-call requirements to ensure 24 x 7 support of database operations
Additional duties as assigned.

Technical Skill
Preferred Bachelor's degree in information technology/computer science or engineering field.
Minimum 10 years experience supporting Oracle, PostgreSQL and MySQL databases in an enterprise environment.
Sound knowledge of Oracle, Goldengate, PostgreSQL and MySQL with the ability to transfer knowledge to other team members.
Ability to Support RDBMS in both Linux and Windows environments.
Experience in troubleshooting problems and forming a resolution with IT systems and individuals.
Ability to interact with Customer SME s in a clear, concise, professional manner
Able to make effective decisions in high-pressure situations, with limited management escalation.
Exceptional written and verbal communication skills.
Candidate must be authorized to work in the U.S. We are unable to sponsor work visas at this time.

About HCL

HCL Technologies (HCL) empowers global enterprises with technology for the next decade today. HCL s Mode 1-2-3 strategy, through its deep-domain industry expertise, customer-centricity and entrepreneurial culture of ideapreneurship enables businesses to transform into next-gen enterprises.
HCL offers its services and products through three lines of business - IT and Business Services (ITBS), Engineering and R&D Services (ERS), and Products & Platforms (P&P). ITBS enables global enterprises to transform their businesses through offerings in areas of Applications, Infrastructure, Digital Process Operations, and next generation digital transformation solutions. ERS offers engineering services and solutions in all aspects of product development and platform engineering while under P&P. HCL provides modernized software products to global clients for their technology and industry specific requirements. Through its cutting-edge co-innovation labs, global delivery capabilities, and broad global network, HCL delivers holistic services in various industry verticals, categorized under Financial Services, Manufacturing, Technology & Services, Telecom & Media, Retail & CPG, Life Sciences, and Healthcare and Public Services.
As a leading global technology company, HCL takes pride in its diversity, social responsibility, sustainability, and education initiatives. As of 12 months ending on September 30, 2019, HCL has a consolidated revenue of US$ 9.3 billion and its 147,123 ideapreneurs operate out of 44 countries. For more information, visit
www.hcltech.com
Candidate must be authorized to work in the U.S. We are unable to sponsor work visas at this time.

About HCL

HCL Technologies (HCL) empowers global enterprises with technology for the next decade today. HCL s Mode 1-2-3 strategy, through its deep-domain industry expertise, customer-centricity and entrepreneurial culture of ideapreneurship enables businesses to transform into next-gen enterprises.
HCL offers its services and products through three lines of business - IT and Business Services (ITBS), Engineering and R&D Services (ERS), and Products & Platforms (P&P). ITBS enables global enterprises to transform their businesses through offerings in areas of Applications, Infrastructure, Digital Process Operations, and next generation digital transformation solutions. ERS offers engineering services and solutions in all aspects of product development and platform engineering while under P&P. HCL provides modernized software products to global clients for their technology and industry specific requirements. Through its cutting-edge co-innovation labs, global delivery capabilities, and broad global network, HCL delivers holistic services in various industry verticals, categorized under Financial Services, Manufacturing, Technology & Services, Telecom & Media, Retail & CPG, Life Sciences, and Healthcare and Public Services.
As a leading global technology company, HCL takes pride in its diversity, social responsibility, sustainability, and education initiatives. As of 12 months ending on September 30, 2019, HCL has a consolidated revenue of US$ 9.3 billion and its 147,123 ideapreneurs operate out of 44 countries. For more information, visit
www.hcltech.com

Requirements


Knowledges:

  • Utilities
  • Linux
  • MySQL

Machinist

Job Description Job Opportunity: Machinist with RL Industries in Fairfield, OHDo you thrive on fabricating component parts? Are you skilled at operating a...


Ohio

Published a month ago

Laborer (full time : permanent)

Job Description Our client specializes in fine precast concrete site furnishings. They are looking for a Concrete Team Member. This position has the...


Arizona

Published a month ago

Federal construction superintendent

Job Description Firm is looking for a qualified individual who has the experience and qualifications to act as the project superintendent, Safety, and Quality...


New Jersey

Published a month ago

Building engineer

Job Description 6 month contract that could lead into extension or permanent placement Facilities / Systems Engineer III (Sr. Engineer) Must not be allergic...


Illinois

Published a month ago