Database Administrator Job in Ascentx Software @ Uplers

Job Description

JOB TITLE: Database Administrator NO. OF POSITIONS: 1 EXPERIENCE REQUIRED: 3 + Years LOCATION: Chandigarh EDUCATION: B.Tech, BE, MCA INDUSTRY: IT-Software / Software Services KEY SKILLS: Oracle, RMAN, RAC, 11g,12c, DBA, SQL, PLSQL, Database Administration, Database Architecture, Performance Tuning 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 Assist Application Team for Following : 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. Puts standards in place to ensure that all application design and code is produced with proper integrity, security and performance. The DBA will perform reviews on the design and code frequently to ensure the standards are being adhered to 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 Capacity planning for databases and database servers : 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 Deployment & Support Activities : 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 Desired Skill: 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),

Employement Category:

Contact Details:

+ View Contact

×

Login

Candidates can login here to view contacts and apply.

Sign In Sign Up

Email:

Password:

Password too short

To create your profile, apply for a job or make a registration

Sign In Close

Your name (*)

Email (*)

Mobile (*)

Preferred City (* max. 2 w/comma)

Designation / Expected Role

Current / Recent Company (*)

Experience (*)

0 - 1 Yrs 1 - 2 Yrs 2 - 3 Yrs 3 - 4 Yrs 4 - 5 Yrs 5 - 6 Yrs 6 - 7 Yrs 7 - 8 Yrs 8 - 9 Yrs 9 - 10 Yrs 10 - 11 Yrs 11 - 12 Yrs 12 - 13 Yrs 13 - 14 Yrs 14 - 15 Yrs 15 - 16 Yrs 16 - 17 Yrs 17 - 18 Yrs 18 - 19 Yrs 19 - 20 Yrs 20 - 21 Yrs 21 - 22 Yrs 22 - 23 Yrs 23 - 24 Yrs 24 - 25 Yrs 25 - 26 Yrs 26 - 27 Yrs 27 - 28 Yrs 28 - 29 Yrs 29 - 30 Yrs 30+ Yrs

Expected Salary (*)

Rs 0 - 50K PM Rs 50K - 1 LPA Rs 1.0 - 1.5 LPA Rs 1.5 - 2.0 LPA Rs 2.0 - 2.5 LPA Rs 2.5 - 3.0 LPA Rs 3.0 - 3.5 LPA Rs 3.5 - 4.0 LPA Rs 4.0 - 4.5 LPA Rs 4.5 - 5.0 LPA Rs 5 - 6 LPA Rs 6 - 7 LPA Rs 7 - 8 LPA Rs 8 - 9 LPA Rs 9 - 10 LPA Rs 10 - 12 LPA Rs 12 - 14 LPA Rs 14 - 16 LPA Rs 16 - 18 LPA Rs 18 - 20 LPA Rs 20 - 22 LPA Rs 22 - 24 LPA Rs 24 - 26 LPA Rs 26 - 28 LPA Rs 28 - 30 LPA Rs 30 - 32 LPA Rs 32 - 34 LPA Rs 34 - 36 LPA Rs 36 - 38 LPA Rs 38 - 40 LPA Rs 40 - 42 LPA Rs 42 - 44 LPA Rs 44 - 46 LPA Rs 46 - 48 LPA Rs 48 - 50 LPA Rs 50 - 75 LPA Rs 75 Lakh - 1C PA Rs 1 Crore+ PA

Desired Industry (*):

Accounting / Finance Advertising / MR / PR / Events Agriculture / Dairy Animation / Multimedia Architecture / Interior Design Astrology Automobile / Auto Ancillaries / Auto Components Aviation / Airline / Aerospace / Aeronautical Banking / Financial Services / Broking BPO / Call Center / ITeS Brewery / Distillery Broadcasting Cement / Building Material Chemical / Petro / Plastic / Rubber / Glass Consumer Electronics / Appliances / Durables Courier / Transportation / Freight Defence / Government Education / Teaching / Training Electricals / Switchgears Engineering / Construction / Cement / Metals Environment / Waste Management Export / Import / Trading Facility Management Fertilizers / Pesticides FMCG / Foods / Beverage Food Processing Furnishings / Ceramics / Sanitaryware / Electricals Gems / Jewellery Gifts / Toys / Stationary Government / Departmental Heat Ventilation / Air Conditioning Hotel / Restaurant Industrial Design Industrial Products / Heavy Machinery Insurance Internet / E-Commerce IT - Hardware / Networking IT - Software / Services KPO / Research / Analytics Leather / Leather Products Legal / Courts Logistics / Courier / Transportation Management Consulting / Strategy Manufacturing / Production Matrimony / Matchmaking Media / Entertainment Medical / Healthcare / Hospital Merchant Navy Metal / Iron / Steel MFI - Micro Finance Military / Police / Arms Ammunition Mining / Quarrying NBFC-Non Banking Financial Services NGO / Social Work Office Equipment / Automation Not Mentioned Paint / Art / Sculpture / Craft Paper / Wood Personal Care / Beauty Pharma / Biotech / Clinical Research Politics Power / Energy / Oil / Gas / Petroleum Printing / Publishing / Packaging Quality Certification Real Estate / Property Recruitment Services / RPO Religion / Spirituality Retail Security / Detective Services Semiconductors / Electronics Shipping / Marine Telecom / ISP Textile / Garments / Fashion Travel / Tourism / Hotels / Airlines / Railways Unskilled Labor / Domestic Help Veterinary Science / Pet Care Sports / Fitness / Beauty

Functional area / Department (*):

Accounts / Finance / Tax / CS / Audit Agent / Agency Analytics & Business Intelligence Architecture / Interior Design Banking / Insurance Beauty / Fitness / Spa Services Content / Journalism Corporate Planning / Consulting CSR & Sustainability Engineering Design / R&D Export / Import / Merchandising Fashion / Garments / Merchandising Guards / Security Services Hotels / Restaurants HR / Administration / IR IT- Hardware / Telecom / Technical Staff / Support IT Software - Application Programming / Maintenance IT Software - Client Server IT Software - DBA / Datawarehousing IT Software - E-Commerce / Internet Technologies IT Software - Embedded /EDA /VLSI /ASIC /Chip Des. IT Software - ERP / CRM IT Software - Mainframe IT Software - Middleware IT Software - Mobile IT Software - Network Administration / Security IT Software - Other IT Software - QA & Testing IT Software - System Programming IT Software - Systems / EDP / MIS IT Software - Telecom Software ITES / BPO / KPO / Customer Service / Operations Legal Marketing / Advertising / MR / PR Pharma / Biotech / Healthcare / Medical / R&D Packaging Production / Maintenance / Quality Purchase / Logistics / Supply Chain Sales / BD Secretary / Front Office / Data Entry Self Employed / Consultants Shipping Site Engineering / Project Management Teaching / Education Top Management Ticketing / Travel / Airlines TV / Films / Production Web / Graphic Design / Visualiser Other Areas

Enter Skills (key skills, subjects, technologies & roles to use in search)

Write briefly about yourself, your experience and education (*)

500 characters remaining

Attach Resume  Max 2.38 MB (RTF, PDF, DOC, DOCX formats only parsed)

Please, check the file size and type.

Add social media [ + ]

Create password

I agree with website service terms and conditions

Sign Up Close

Candidates are expected to provide most recent and accurate profile information, inappropriate content is strictly prohibited!

Keyskills:   Oracle RMAN 11g SQL PLSQL Database Administration Database Architecture Performance Tuning RAC DBA