Application DBA Resume

SUMMARY:

With 10 years of experience as a database professional and 1+ year in AWS, specializing in the Analysis, Design/Modeling of databases and implementation (Oracle database) and Database Application Maintenance as well as Development using PL/SQL.
Data Warehousing Technologies and Application Development using Informatica, Data stage, Oracle (SQL, PL/SQL), UNIX Shell Scripting and Control - M, Zena and Remedy.
Worked as application DBA in creating table spaces, users, roles etc.,
Extensively worked on query/database performance tuning.
Actively involved in the project migration into AWS environment to use various AWS services.
Automation of batch jobs/scripts done in Control-M, Zena and Remedy with Unix/Perl jobs.
Experience of working in heterogeneous project/team structure (including onsite-offshore delivery model) as an Individual Contributor as well as a Team Lead- designing solutions and managing deliverable.
Highly approachable team-player and motivated with strong commitment to quality.

AWS SKILLS:

Configured AWS CLI and performed necessary actions on the AWS services using shell scripting.
Creating and managing S3 buckets (CLI)
Loading files from S3 bucket to Database staging tables by using shells script.
With the help of IAM created roles, users and groups and attached policies to provide minimum access to the resources.
SNS creation for email notification
Worked on the Amazon RDS and carried out functionalities for creating instances as per the requirements.
Worked on the databases of the Amazon RDS and carried out functionalities for creating instances as per the requirements.
Migrating Oracle Database to AWS cloud
Migrating Data for Small Oracle Databases using (Oracle SQL Developer Database Copy, Oracle Materialized Views, Oracle SQL*Loader, Oracle Export and Import Utilities)
Migrating Data for large Oracle Databases using (AWS DMS, Oracle Data Pump, External Tables, Oracle RMAN)

KEY EXPERTISE:

Database: Oracle

Languages: SQL, PL/SQL

DWH Tools: Informatica (ETL), DataStage

Tools: Toad, Sql developer, Oracle Data Modeler, Visio, Bugzilla, SQL Ways (migration tool), Source Safe, Zena, Control-M, Remedy, SVN

Operating Systems: Windows, Linux and Unix

Digital Skills: AWS services (IAM,S3,SNS,EC2,VPC,Route 53,auto scaling, RDS, Cloud formations, Lambda, cloud watch)

PROFESSIONAL EXPERIENCE:

Confidential

Application DBA

Responsibilities:

Understand the project and module functionality, technical and functional support to team member.
Taking responsibility as onsite Lead and co-ordinate with offshore coordinator regarding project plan, deliverable timeline and task plan for new Change request and enhancement
Configuring CLI for accessing S3 buckets.
Creating IAM user and adding into respective development groups after client approval
Providing access to EC2 machine for new users after client approval
Oracle procedures, function, package development and enhancement based on functional requirement. preparing design specification, user manual, admin guide based on client’s requirement developing SQL and PL/SQL scripts to verify the data as well as generate user specific report, review the PL/SQL code of team member.
Oracle (SQL and PL/SQL) performance tuning within the application. developing and testing Oracle Stored Procedures, Functions and Packages performance improvement processes
Creating table spaces, users, roles etc.,
Working on scheduled jobs, database links, synonyms etc.
Automation of, downloading source files from user server to S3 buckets staging source files from S3 buckets to staging tables extracts the files from database facts tables to S3 buckets archive process for old files on S3

Confidential

Application DBA

Responsibilities:

Provide a validation of the data
Prepare loss and premium data for pricing analysis
Measure the impact of rate changes
Determine impacts of new rating plans
Provide ability to respond quickly and efficiently to DOI requests and State Filing needs.
Interaction with the Clients for new change request and issue analysis in backend site.
Review analyze the services system.
Perform exercises related to Web Services Production issues.
Analyzed and Fixed the Production issues in the Complex database objects like Stored Procedures etc.,
Writing SQL, Pl/Sql code - performance tuned as per requirement
Coding which involves new change request and defect fixing.
Handled unit testing and code deployment process in Dev & Testing region. scheduled jobs, database links, synonyms etc.