Oracle Database Administrator is responsible for installation and maintaining number of databases required for development, testing, and production usage.
Performs the capacity planning required to create and maintain the databases.
Works closely with system administrators for applications or tools in addition to the Oracle Databases.
Performs ongoing tuning of the database instances.
Implements and enforces security for all of the Oracle Databases.
Plans and implements backup and recovery of the Oracle database.
Evaluates releases of Oracle and its tools, performs planning along with the application developers and System administrators, to ensure that release upgrade takes place with minimal impact.
Enforces and maintains database constraints to ensure integrity of the database.
Create new database users as required. Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
Assists with impact analysis of any changes made to the database objects. Regular monitoring of systems, tunes the databases to achieve optimal performance.
Candidate having 3 to 5 Years ( Proven experience of Managing Large Scale databases in a Production Environment in Oracle 10g,11g,12c-
Hands on experience of managing Exadata and experience of Configuration / Troubleshooting and Administration of Oracle Database with RAC and Dataguard™ with Oracle Enterprise Linux.
Strong database administration Skills including installation, patching HA, backup and recovery etc.
Strong skills in RMAN, data pump, Export/Import, Hot/Cold Backup. Strong skills in database Performance Tuning.
Knowledge and experience of Linux administration.
Good Working Knowledge of SAN.
Professional working experience Oracle 11g, 12C.
Partitioning, Oracle In-Memory, Oracle Active Data Guard
Oracle Certification. Excellent communication skills both verbal & written. Ability to work in a team environment & learn new technologies. Experience in looking after 24×7 environments. Be able & available to work on Production issues after hours or on weekends.
Experience in working under a production support & pressured environment. Troubleshooting, problem-solving and able to drive issues to resolution.
Experience in performing health checks of database system.
Be able & available to work on Production issues after hours or on weekends. Experience in working under a production support & pressured environment.
Troubleshooting, problem-solving and able to drive issues to resolution.
Experience in performing health checks of database system. Configuration of Oracle Golden Gate and Oracle DB and Audit Vault is a plus.
The SQL Server Database Administrator (DBA) will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of our corporate applications. This is a “hands-on” position requiring solid technical skills on MS SQL Server 2012, 2017 ,2019 etc.
Responsible for providing technical support for the establishment of different database environments like Test, training, and Production.
Ensuring Business RPO/RTO by taking all necessary measures for all databases
Troubleshoot SQL Server service outages as they occur on call or on weekends from home.
Implementation of High Availability of Data (HA)/DR techniques to avoid Data Loss
Ensure documenting company’s database environment, Disaster Recovery strategies, Audit polices to fulfill requirement of audits.
Ensuring performance and security of database environment
Excellent communication skills both verbal & written.
Ability to work in a team environment & learn new technologies.
Be able & available to work on Production issues after hours or on weekends.
Keen to learn new tools and technologies.
Hands-on experience with MS SQL Server 2012, 2017, 2019.
Working knowledge of SSIS, database replication especially transactional replication, SQL Server Tools (SQL Profiler, Performance monitor, DMVs)
Working experience of Performance tuning, query optimization techniques, Backup & recovery methods in SQL Server.
Hands on experience of Database partitioning.
Working experience in identifying & resolving performance bottlenecks of databases
Strong skills in T-SQL. Basic knowledge of cluster management, HA & DR methodologies.
Able to translate business requirements into test cases.
Contribute to establishing automation test framework to support all aspects of Quality Assurance, including the execution of test plans to perform both functional and non-functional testing.
Perform manual test execution to verify software implementation meets the business requirements Install builds into test environments and help troubleshoot issues in test environments.
Troubleshoot automated test failures that run as a part of Continuous Integration process.
Document bugs and issues with enough details to reproduce the item and verify the issue has been resolved after it has been fixed.
Deliver estimates in collaboration with the feature team and stakeholders.
Research and collaborate with their engineering team on continuous improvement initiatives.
Bachelor's/Masters in Computer Science, from some reputed foreign or HEC-recognized institution.
Candidate must have minimum 2 years of experience.
Experience in the following automation testing tools; Selenium,JMeter,Cypress,Appium etc
Experience with Automated UI Testing.
Experience with distributed version control (e.g. Git)
Understanding of Continuous Integration/Development Experience with Lean/Agile/Scrum
Bs (Computers science)(16 years) or equivalent
Relevant certifications (e.g., Microsoft Certified: Windows Server, VMware Certified Professional) are a plus.
2 Years (Candidates with relevant certifications will be preferred.
We offer market-based compensation and benefits. Our benefits include generous health insurance coverage for self, spouse, children and parents (inpatient and outpatient), unrivaled group life insurance, above average annual salary raises, lucrative annual bonuses, gratuity, loans and leave encashment etc.
We foster an open and friendly environment that encourages diversity and equal employment opportunity. We put extra efforts and energy to create a workplace that focus on employees well-being physical and mental health, high level of engagement through HR best practices.
Our Software Development Life Cycle (SDLC) offers unique learning opportunity to every team member to learn and become a specialist of either any specific technology or multiple tools and technologies. That creates unparalleled opportunities for career advancement. We aim to invest significantly on our employees learning and development.
Over the years, we have achieved and maintained an outstanding work life balance, yet we do not miss our timelines. In fact, this is helping us to do our work more efficiently maintaining productivity and quality. We are also flexible to opt for remote/ hybrid working whenever there is a requirement or need.
©2022 PRAL, All rights reserved.