Database and Application Admin Resume

SUMMARY

Worked in Confidential Customer Care & Billing utility.
Knowledge of billing and batch processing system of Confidential CC&B utility.
Data Migration using Sql and PL/SQL scripts.
Knowledge of how to write queries, procedures, functions, triggers.
Database and Application Admin Support.
Installation and Configuration of Confidential databases
Troubleshooting database and application servers issues on daily basis.
Knowledge of RMAN Backup and recovery,Data Guard.
Creating and managing tablespaces and Data files.
Creation of users, roles, profiles and privileges.
Schema refresh.
Managing Production, Test & Development databases.
Handling Database corruption if any in test servers.
Extensively used DBA Utilities Data pump, RMAN & Data guard
Knowledge of database architecture
Export & Import database objects for application s testing purpose
Creating users, database objects, granting privileges.
On - call Support, worked in 24* 7 environments

PROFESSIONAL EXPERIENCE

Confidential

Database and Application Admin

Responsibilities:

Worked on Data Migration Activity from RMS(Revenue Management System) to Confidential CC&B using PL/SQL scripts.
Responsible to handle queries coming from development and support team relevant to Application and Database admin profile.
Managing and monitoring application Servers and Batches.
Deployment of JSP, Java and War file on production and test application servers and WebLogic console .
Compiling packages & procedures on production database servers, execution of database queries on production databases.
Manually starting and stopping database and application services.
Installation and configuration of Confidential Database 11g.
Creation of database manually and using DBCA .
Troubleshooting database and application issues on daily basis.
To make sure synchronization and replication of archive logs from DC to DR.
Worked on DBA Utilities Data pump, RMAN, Data Guard.
Managing redo Logs, control files, data files and archive logs.
Creating and managing tablespaces and Data files
Create, schedule and manage database jobs.
Export & Import database objects for application s testing purpose
Managing production, development and test databases.
Monitoring logs and queries.
Database purging activity.
Handling the first level escalations
Creation of users, roles, profiles and privileges.
General database monitoring, handling DBLinks.
Moving database objects for application s testing purpose via datapump Utility.
Monitoring of space management in database.
Preparing & publishing database quarterly reports.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship