SUMMARY:

• A versatile IT professional with 12 years of comprehensive experience as an Oracle Database Administrator, AWS Solutions Architect and DBA Lead /Manager. Having hands on experience in Oracle Database Administration working both on Production and Development environments, installation, configuration, upgrades, patches, performance tuning, backup and recovery, database security, cloning, migration, and documentation in high - availability environments with Oracle 12C/11G/10G/9i/8i, RAC support and AWS and Amazon RDS Cloud.
• Worked on various environments involving several domains like Telecom, Banking, Finance, Retail, Energy and Oil for major clients on all OS in mission critical OLTP and OLAP Environments.
• Excellent experience in Installation, administration and troubleshooting of Oracle 12c/11g/10g/9i and 8i for OLTP (multiple instances)/ OLAP environment on Very Large Databases.
• Managed Database team of 12 DBA’s including their appraisal process and mentored them for delivering successfully to large clients with very good coordination and 100 % success rate.
• Experience on Handling 50 + Production and 100 + Dev Databases.
• Expert-level knowledge of Amazon EC2, Amazon S3, Amazon SimpleDB, Amazon RDS, Amazon Elastic Load Balancing and other services of the AWS infrastructure.
• Provided security and managed user access and quota using AWS Identity and Access Management (IAM), including creating new Policy.
• Configured logs storage to AWS S3 time to time and archive off to AWS Glacier based on the retention policy of applications and databases.
• Leading Team in the critical situations as SME resolving all critical scenarios faced as part of support.
• Dealt and managed teams both Confidential onsite and offshore in different levels of project.
• Handled planned/ Un-planned complex outages of production servers coordinating with other teams with quick restorations swiftly communicating with involved teams.
• Managed large sized projects as per the client business requirements.
• As a Lead, dealt many complex issues and fix them positively by evaluating the new areas to improve by suggesting the ways to adopt newer technologies whenever required.
• Achieved many client appreciations ranging from various clients VP to client CEO for best work delivered.
• Created many database policies as per the project requirements, proposing newer methodologies by proposing them in the change management meetings for effective delivery.
• Successfully implemented oracle 12C environment on databases upgrading from oracle 11.2.0.3.
• Built and managed many large scale databases and was accountable for successful support of the databases built.
• Completed a highly reputable No-SQL database MONGO DB for DBA’s training from Confidential
• Completed and certified on a highly reputable cloud services - AWS solutions architect Associate.
• Involved in Installation, maintenance and tuning of RAC Applications.
• Plan GoldenGate setup to achieve Unidirectional replication and setup GoldenGate Database User with necessary privileges.
• Created oracle databases and troubleshoot on AMAZON RDS cloud environment
• Expertise in setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Enterprise Manager (OEM).
• Expertise in Oracle 10g/9iData Guard and standby databases, Snapshot maintenance and creation
• Regular interaction with client and customer managers, development teams and system administrators in coordinating projects successfully.
• Performed key role in preparing external database Audits and fulfilling the gaps for POSITIVE Audit result in making databases ready, guiding both offshore and onsite teams.
• Guided team in all phases of the application life cycle from proof of concept and initial development through production implementation and operations.
• Excellent in leading, team managing, mentoring, and coaching team members both Confidential onshore and offshore locations.
• Oracle Problem analysis and resolution and active cloning of databases from one server to another server.
• Database refresh from production to QA, development and testing environments Backup and recovery methods including point in time, media recovery, full/partial, and data pump export/import.
• Supported very large Data Warehouse databases, de-normalized schemas, and Performance related issues.
• Detecting and diagnosing production system performance problem by analyzing STATSPACK reports, Oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database activity, Querying Oracle dynamic performance views.
• 24/7 on-call production database support.
• Experience in configuring and Installing/using various Quest Tools- Foglight, Performance Analysis.
• Attended Six Sigma training & worked for Six Sigma Project.

PROFESSIONAL EXPERIENCE:

Confidential, St. Louis, MO

AWS Solutions Architect

Responsibilities:

• Design and Build both Production and development databases as per business requirements.
• Managing Database team of 8 DBA’s including their appraisal process and mentored them for onboarding and off boarding for large clients with very good coordination and 100 % success rate.
• Provided security and managed user access and quota using AWS Identity and Access Management (IAM), including creating new Policy.
• Configured logs storage to AWS S3 time to time and archive off to AWS Glacier based on the retention policy of applications and databases.
• Integrating the data into Amazon Web Services from multiple sources and configuration of the system with Amazon Command line interface and Amazon Web Portal as well.
• As per the client’s request, commissioning and decommissioning the websites hosted in the company’s environment and creating Amazon Machine Image of the instances.
• Best DBA from the client working for ZERO DEFECT and 100% SLA’s.
• Supporting as ADBA, application DBA role for all the U-verse and Confidential validations project
• Installed Oracle 10g and 11g RAC software with ASM & OCFS2 File systems.
• Managed large sized projects as per the client business requirements.
• Handled planned/ Un-planned complex outages of production servers coordinating with other teams with quick restorations swiftly communicating with involved teams.
• Mentored a direct reporting team and indirect reportees including onsite and offshore locations.
• Monthly maintenance tasks performed on critical servers and applying required patches and database downtime work.
• Maintain strict documentation for all the work done, coordinate and manage the team to be in compliant with company procedures for anytime Audit review.
• Planned and maintained the database architecture in the current environment and suggested for changes.
• Involved in Installation, implementation and maintenance of relational databases, performance monitoring and tuning, capacity planning, problem analysis and correction,
• Maintain 24*7 Availability by implementing standard processes and troubleshooting live issues within defined tight SLA times
• Manage High Availability Architecture with clustered environment on both PROD and DEV databases of Confidential & Confidential .
• Maintain daily health checks and send reports to concerned teams.
• Troubleshoot Database Performance issues using OEM,AWR, ASH, TKPROF 10046 traces etc.
• Guided all phases of the application life cycle from proof of concept and initial development through production implementation and operations.
• Database Capacity Management (Working with Storage teams for ASM Disks) using Automated scripts/processes and Reports.
• Dynamic Change management Environment - Critical production changes are planned and implemented on daily basis with thorough review process in place.
• Manage Database and Archive log backups using RMAN and External third party tools like Netapp backups.

Environment: Oracle 12C/11g/10g/9i/8i, AWS (EC2, VPC, ELB, S3, RDS, Cloud Trail and Route 53, VDI), RHEL, Solaris, AIX and Windows 2003 server, OEM 12C, TOAD, REMEDY, FogLight, FTP professional, EMC Wizard, putty.

Confidential, Louisville, KY

AWS Solutions Architect

Responsibilities:

• Managing Database team of 10 DBA’s including their appraisal process and mentored them for onboarding and off boarding for large clients with very good coordination and 100 % success rate.
• Received many accolades and pat on back s from the client and company fir the delivery.
• Active role in performing external database Audits and fulfilling the gaps for POSITIVE Audit in making database ready, guiding both offshore and onsite teams.
• Created, maintained and administered databases on AMAZON RDS cloud.
• Build servers using AWS: Importing volumes, launching EC2, creating security groups, auto-scaling, load balancers, Route 53, SES and SNS in the defined virtual private connection.
• Creating alarms in Cloud Watch service for monitoring the server performance, CPU Utilization, disk usage etc.
• Assigning AWS Elastic IP Addresses needed to work around host or availability zone failure to quickly remap the address to other Running instances.
• Enhanced the overall performance of AWS, RDS, MySQL database instances, by increasing the architectural class definition of specific instances.
• Configured AWS RDS MySQL database users to allow each individual user privileges to perform their related tasks.
• Created many database policies as per the project requirements, proposing newer methodologies by proposing them in the change management meetings for effective delivery.
• Analyzing and solving the performance problems arising out of critical applications on the invoicing days.
• As a Lead, dealt many complex issues and fix them positively by evaluating the new areas to improve by suggesting the ways to adopt newer technologies whenever required.
• As DBA Lead, Regularly been part of change management meetings for any changes to the databases and proposals.
• Built and managed many large scale databases and was accountable for successful support of the databases built.
• Plan GoldenGate setup to achieve Unidirectional replication
• Setup GoldenGate Database User with necessary privileges
• Database copy downs whenever required for development teams.
• Application upgrades on the databases for various clients of fuelquest supporting off hours in making the application versions up to date coordinating with team and various other involved teams.
• Created size based databases on Amazon RDS cloud as Small and XL databases
• Cloning the databases when required for development and testing activities using EMC Wizard.
• Maintained 3 RAC databases and involved in migrating to cloud based databases from RAC cluster to NetApp VM ware.
• Monitoring the daily backups of all the production databases.
• Imported and exported files, databases, schemas and tables using utilities when required.
• Guided DBA team in setting up new servers from scratch to creating databases and using them dedicatedly for using Quest foglight and performance analysis of databases exclusively
• Performance tuning via AWR and Improved Performance of the database by troubleshooting whenever payroll run happens on the database for high performance output.
• Resolved table space issues, disk space issues and problems like listener down, tnsnames errors etc from the end user interaction.
• Responsible to ensure that the environments are stable and Confidential acceptable performance.
• Developed Cron jobs to automate the backups, monitoring Alerts.
• Allocating system storage and planning future storage requirements for the new environment to be set up.
• Extended Work on planned weekend outages for critical projects and bug fixes based on the criticality.

Environment: Oracle 10g, and 11g, SQL, AMAZON RDS Cloud, AWS EC2, S3, Route53, EBS, IAM, ELB, Cloud watch, Cloud Formation, RHEL, RAC, GoldenGate, Oracle Enterprise Manager (OEM), SQL plus, Putty, RMAN, JIRA Tool, FTP professional, WINSCP, TOAD, Solaris and Linux, EMC wizard, Foglight.

Confidential, Houston, TX

Senior Oracle DBA / Lead DBA

Responsibilities:

• Managed 4 onsite reportees and 6 offshore reportees as part of DBA support team.
• Providing production and development database support and maintaining them stable.
• Installation of ORACLE 9i and 10g Database on different Environments
• Installation of OEM Grid Control and OEM Agents to Manage up to 100 Databases.
• Performing capacity monitoring and short and long-term capacity planning in collaboration with development resources, system administrators and system architects
• Design ORACLE ASM Disk and Disk group layout in collaboration with system administrators and system architects
• Support of daily operations including job monitoring and troubleshooting of the 24x7 production
• Design, develop, and maintain back-up strategy using Centralized RMAN Shell Script and expdp/impdp
• Keeping the database up to date on patches and Supporting the roll-out of new versions
• Involved in Oracle database designing using ERWIN tool for development projects coordinating with development teams.
• Logging support cases as necessary and effectively working with Oracle to resolve issues
• Involve in all phases of software development lifecycle, including data analysis, business analysis, testing and documentation development
• Worked on the Service Now to handle user tickets, Incidents and Service requests.
• Presented and explain technical information of diverse type of audiences such as management, users, vendors and technical staff in a way that establishes rapport, persuades other and gains understanding.
• Adherence to policies, procedures and controls especially in regard to outage and change management, licensing, and information protection.
• Worked closely with ETL applications team.
• Managing offshore team and setting up 24X7 monitoring.

Environment: Oracle 9i, 10g, and 11g, SQL, NETApp, RAC, Linux, AIX, Oracle Enterprise Manager (OEM), SQL plus, Putty, RMAN, Service Now Tool, ERWIN, TOAD, Solaris and Linux, Exp 9i, 10g, Imp 9i, 10g and Tortoise SVN Tool.

Confidential, Houston, TX

Senior Oracle DBA

Responsibilities:

• Defect less monitoring of all the Production, development and Test databases.
• Responsible for around 60 Oracle databases on 11 servers.
• Maintained instances of around 750GB to 30 TB.
• Configuring database entries, monitoring and maintaining user security for all of the databases using Oracle Enterprise Manager (OEM) Grid Control.
• Actively involved in the team to migrate RAC databases to EXADATA systems to startup with quarter RACK.
• Major Aviation databases have been migrated to quarter RACK of EXADATA which was supported and maintained by the team worked.
• Troubleshooting on the databases on user issues on performance related issues.
• Involved in development and implementation of Data ware house and Data mart Design.
• Worked on 2 nodes RAC databases.
• Worked on performance issues related to RAC Cluster Interconnect performance.
• Data Refresh from Production to Test and Development environments using clone refreshes and using Exp/Imp utilities..
• Created database objects like tables, indexes, synonyms, views etc. using SQL* Plus and TOAD.
• Analyzing tables and indexes for performance tuning. Optimizing database objects and streamlining applications.
• For the purpose of improving the performance of queries, created Bit-map Indexes.
• Restored and Recovered database Confidential the times of occurrence of critical failures using RMAN.
• Extensive used Oracle Data pump, Exports/Imports utility for moving data among the servers.
• Created user accounts, roles and granting required access permissions and privileges to the database based on the application they are accessing
• Since most of the data pertains to the personal information of the customer, security is of the utmost importance, so naturally I was involved in designating the roles and privileges to the application developers.
• Extensive using of the flash back technology to get the accurate versions of the data in the times of partially completed transactions.
• Monitoring CPU usage, I/O Contention, memory paging on UNIX server. Provide technical direction to system administrator.
• Extending support for Daily Data Loads so that the loads get completed within agreed SLA time.

Environment: Sun Solaris 9.0/10.0, Linux, AIX, Oracle 8i/9i/10g, RAC, Toad, SQL*Loader, HPSD, PL/SQL, OEM Grid, RMAN, Erwin 4.1.2,EXP/IMP tool.

Confidential, Atlanta, GA

Oracle DBA Team Lead

Responsibilities:

• Prepared a reference document called Issue - Approach for all the issues faced during the tenure.
• Worked with Development team for performance issues.
• Developed Cron jobs to automate the backups, monitoring Alerts.
• Performance Tuning for hung sessions and long running quires in the database based on user requests.
• Created roles and assigned them to users. Granting privileges on tables.
• Extended Work on planned weekend outages for critical projects and bug fixes.
• Worked on the HPSD to handle tickets and Work Order requests.
• Volumetric estimations for creation of new table space for data marts.
• Implemented database alerts, automated rollback segment shrinking.
• Planned and executed RMAN and cold backup strategies and recovered database.
• Handled planned/ Un-planned outages of production servers.
• Ensuring regular hot backups & archive backups
• Refreshing of production data to Dev/QA environments.
• Performing re-sizing of data files, managed tablespaces and data files
• Created partitions & indexes for better performance.
• Setup backup and recovery procedures using RMAN. Performed hot and cold backups using RMAN.
• Customization and development of Korn shell scripts.
• Troubleshoot application - related issues and supporting offshore team.
• Documenting all the issues and resolutions in a Fail N Fix document for the future reference of the same issue.
• Space Management/Monitoring - Temp TBSP, RBS, Data Space, Swap, archive file system. Data Loading using SQL Loader
• Logging tickets with GIS (Global Information Systems) in case of server/ hardware issues, restoration.

Environment: Oracle 8i, 9i, 10g, SQL, Oracle Enterprise Manager (OEM), SQL plus, Putty, RMAN, Cadre Tool, TOAD, Solaris, AIX, and Linux, Exp 9i, 10g, Imp 9i, 10g, Data pump 10g.

Confidential, Stamford, CT

Oracle Database Administrator

Responsibilities:

• Performing regular database backups, creating and setting up new scripts and schedules for the backups and exports.
• Refreshing the QA database from the production instance.
• Monitoring and tuning the oracle development environment.
• Assisting developers and data modeling teams.
• Performing capacity planning and space management.
• Developing and publishing development-coding and coding-documentation standards.
• Troubleshooting database/application problems reported by system developers & users.
• Administering user accounts, roles, tables, indexes, sequences, views, etc.
• Installed and configured Oracle databases for Energy Trading on Windows and HP-UX.
• Refreshed several databases on daily basis
• Maintained physical remote standby
• Attended meetings and gave appropriate reports Upgraded 9i to 10g
• Fixed ad-hoc issues with databases and applications and coordinated with various teams worked for different issues.

Environment: Oracle 8i, 9i, 10g,, SQL plus, Putty, RMAN, TOAD, Windows server 2008, and Linux, Exp 9i, 10g, Imp 9i, 10g, Data pump 10g.

Confidential

Oracle Database Administrator

Responsibilities:

• Monitoring the Database and its Alert Log.
• Proactively Monitored the OS for Space Utilization and any performance issues.
• Assisted in software installation and development environment creation by creating databases and modifying scripts that access them.
• Prepared documentation on software and application installations for training purposes.
• Indexes were implemented wherever they were needed to boost the performance of the quires and to reduce the Locking of the objects.
• The quires executed from the front end were regularly monitored to detect any illegal data manipulation and to detect queries that were blocking the system resources.
• Backed the dump files & DB Backup Created Snapshots for Replication and automatically updating the jobs.
• Experienced with RMAN backups and Oracle exp/imp utilities and Hot/Cold backups
• Provided On-Call rotation support and 24x7 support for very large and critical databases based on the criticality and priority of the issue.
• Created user accounts, roles and granting required access permissions and privileges to the database based on the application they are accessing.
• Updating the issues and dealt using tickets and took periodic backups as per user requirements and requests.

Environment: Oracle 8i, 9i, SQL, Oracle Enterprise Manager (OEM), SQL plus, Putty, RMAN, TOAD, Solaris, Linux and Windows.