Database Administrator
Ascentx Software Development Services Pvt. Ltd.
Date: 1 week ago
City: Chandīgarh, Chandigarh
Contract type: Full time
Roles & Responsibilities
- Oracle Database Administration (11g, 12c)
- Oracle RAC and Data Guard database administration
- Creates & maintains all databases required for development, testing, production and training usage
- Database installations and upgrades, regular PSU & CPU patching for databases
- Interface with Oracle Corporation for technical support
- Register for database alerts and follow-up on db alerts on regular basis and take action as necessary
- Drive the performance analysis and tuning for the database
- Hands on Experience in managing Complex Oracle Environments Spanning multiple Oracle Instances / Servers
- Hands on Experience in Backup and Recovery - RMAN.
- Monitor table and index growth and take proactive measures to maintain and tune storage allocation
- Enforces and maintains database constraints to ensure integrity of the database
- Performs database re-organizations as required to assist performance and ensure maximum up-time of the database
- Provide feedback to Development on needed improvements on serviceability
- Oracle troubleshooting and problem resolution. Must Have desire to troubleshoot and resolve complex Issues
- Operating System Knowledge on Windows / Linux / AIX
- Complete time sheets / Participate in Team status or Scrum calls
- Document work performed
- Interview new candidates
- Monitor performance and proactively tune queries and database objects.
- Assist in design for database modules
- Assist in performance tuning of database code(SQL & PLSQL)
- Assist in design and tuning of reports
- Perform code deployments (db code) in all environments except DEV
- Perform schema refreshes and creating new schemas
- Perform post production support, tuning and bug fixes
- Assist in Data Modeling and maintain Data Models
- Develop and maintain standards & procedures including and not limited to:
- Database Monitoring standards doc.
- PLSQL/Database Development standards doc
- Data Modeling standards doc
- Database Road-maps doc
- Document best practices for Security, Implement security, USERS Access Controls
- Establish and maintain sound backup and recovery policies and procedures
- High Availability and Replication design
- Database and Data Security
- Estimate the database sizing using various estimation techniques or tools and produce the final estimates for tables and databases
- Monitor the CPU and Memory utilization of the db servers accordingly add more CPU or Memory for load balancing
- Involve in all Design calls to provide correct inputs related to database to avoid duplication or redundant data
- Prepare the rollback script incase of reverting the release
- Deploy DB related changes in Production environment
- Confirm the db changes are done appropriately
- Monitor the databases through OEM or AWR reports to confirm if there is no impact because of release changes
- Proficient in English with good communication skills. Co-ordination with internal and external teams required to get things to closure.
- Work as part of a team and provide 24x7 support when required
- Willingness to participate in non-standard working-time models (some off-hours/ weekend work may be required at times)
How to apply
To apply for this job you need to authorize on our website. If you don't have an account yet, please register.
Post a resumeSimilar Jobs
Radiology Req. at UP Lakhipur Salary 5 Lakhs
Grand Consultants,
Chandīgarh, Chandigarh
4 days ago
Radiology Required atLakhipur UPSalary 5 to 5.5 LakhsSitapur UPSalary 5 LakhsBareilly UPSalary 5 to 5.5 LakhsRohtak HaryanaSalary Rs. 5 LakhsChandigarh / TricityPart Time / Full TimeSalary 50 to 60 K per hourDoctor couple can be adjusted in their respective fieldORWe...
Senior Full Stack Software Engineer - MSOL
Emerson,
Chandīgarh, Chandigarh
1 week ago
Job DescriptionJob Summary: If you are a software engineering professional who enjoys critical thinking, solving difficult problems, and islooking for an opportunity to grow, Emerson has an opening for you! This is a work opportunity based in our Mohali, India...
Ionic Developer/ Hybrid app Developer
Betasoft Solutions,
Chandīgarh, Chandigarh
2 weeks ago
Experience : 1-3 yearsJob Description We are hiring a experienced developer to help in the design, development, and delivery of hybrid mobile app. applicant should be knowledgeable in design and development of mobile apps and should also have handled integration...
