SUMMARY

• Having 10+ years of experience as ORACLE & SQL Server DBA with expertise under multiple platforms.
• Extensive experience in supporting databases under AWS EC2, RDS, SQL Server and Redshift administration.
• Design, architect, and support fault - tolerant distributed databases, applications and database clusters for five nines availability and scalability.
• Wide experience in infrastructure layout, provisioning AWS cloud infrastructure with particular reference to cost-management, security, and fault-tolerance.
• Provide project and operations database administrator support for Oracle databases on local and AWS /Redshift cloud servers.
• Responsible for architecting, designing, implementing and supporting of cloud based infrastructure and its solutions.
• Experienced in creating RDS and EC2 instances in AWS Cloud.
• Good understanding of ELB, Security groups, NACL, NAT, Firewall and Route53.
• Working directly with Amazon Web Service architects to help reproduce and resolve customer issues.
• Hands on experience withInstallation, Configuration, Migrations, Oracle Data Guard, Oracle RAC,Oracle ASM, Backup and Recoveryusing RMAN, Disaster Recovery and Patching, upgradingand administering10 Terabytesof Oracle Databases on Oracle 12c/11g/10g/9i
• Solely involved in database cross platform migration and upgradation.
• Possess good knowledge in creating and launching EC2 instances using AMI’s of Linux, Ubuntu, RHEL, and Windows and wrote shell scripts to bootstrap instance.
• Created S3 buckets in the AWS environment to store files, sometimes which are required to serve static content for a web application.
• Maintained the monitoring and alerting of production and corporate servers using Cloud Watch service.
• Worked on the databases of the Amazon RDS and carried out functionalities for creating instances as per the requirements.
• Experienced in S3 Versioning and assigning lifecycle policies to backup files and archiving files in Glacier for cold storage.
• Expertise in designing and implementing Oracle databases, cloning of databases and setting up RAC database.

TECHNICAL SKILLS

Operating Systems: Unix, AIX 4.3, AIX 5.3, Red Hat Linux, OEL, Fedora, Ubuntu, Solaris10,9,8, HP-UX. Windows (NT 4, 2000/2003 Prof/Adv Server, XP Professional)

Databases: Oracle (8i/9i/10g/11g/12c), RAC, RMAN, ASM, Data Guard, AWS, Redshift, Microsoft SQL Server (2000/2005), Enterprise Manager (Oracle & Sql Server), SQL Query Analyzer

DB Utilities: SQL*Loader, Sql*Plus,10g OEM, Grid Control, RMAN, DBCA, DBUA, 10g Data Pump, Toad, Data guard, Export / Import, TKPROF, Statspack.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR / ADDM / ASH.

Languages: SQL, UNIX Shell Scripting, Perl.
PROFESSIONAL EXPERIENCE

Confidential, Schaumburg, IL

AWS Cloud DBA and Oracle/SQL DB Production Support

Responsibilities:

• Managed Amazon redshift clusters such as launching the cluster by specifying the nodes and performing the data analysis queries
• Created monitors, alarms and notifications for EC2 hosts using Cloud Watch
• Experienced in Performance Tuning and Query Optimization in AWS Redshift.
• Actively involved in strategic Backup, Restore and Recovery using RMAN for complete recoverability.
• Involved in Database migration from on premise infrastructure to AWS Cloud.
• Performed Database and Application Performance tuning using EXPLAIN PLAN, TKPROF, Statspack and SQL Tuning.
• Performance tuning for optimized results using tools like AWR and ADDM reports.
• Created and maintained all databases required for development, testing and production usage.
• Worked as part of a team and provided 24/7 support when required.
• Implemented Standby Database and Database Replication to realize database high availability.
• Maintained the monitoring and alerting of production and corporate servers using Cloud Watch service.
• Worked on the databases of the Amazon RDS and carried out functionalities for creating instances as per the requirements.
• Migrated Non-ASM Single Instance to ASM RAC Instance.
• Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle clusterware) & also issues with corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files. Also used the Merge backup for backing terabyte databases. Issues with block change tracking & also flash recovery area.

Confidential, Schaumburg, IL

Database managed services -SDO

Responsibilities:

• Coordinated installation, configuration and deployment of multiple Oracle database server releases.
• Designed and set up databases aligned with company's IT standards.
• Designed & Implemented Disaster Recovery solutions.
• Monitored daily database performance / availability, backup and reporting jobs.
• Planned and implemented database schema and security changes.
• Expertise Server Installation, Configuration, Maintenance, Backups & Restores, Security Management, Data pump, Performance Tuning.
• DBA activities such as configuring Grid events, Regular Backup’s, Replication, Tuning, and troubleshooting performance issues.
• Maintenance and monitoring of oracle 11g/10g database instances hosted on Linux and Sun platform.
• Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning.
• Space Management which includes table space creation, adding new data files.
• Oracle installation, creation of database, which includes physical and logical design.
• Recovered databases and clone applications Using RMAN.
• Installed Oracle Application Express on Oracle 11g.
• Partitioning of large tables for fine tuning performance.
• Designed and implemented crash recovery strategies, and Hot, Cold and Logical backup plans.
• Experience with DBUA/Export and Import to migrate the database.
• Responsible for optimizing data access and performance by tuning indexes.
• Upgrade and Migration of Databases from 10g R2 to 11g R1 and applying patches as per requirement.
• Troubleshoot performance issues for the RAC instances (GC events)
• Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle clusterware) & also issues with
• Corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files.
• Resolved/Diagnose Node Eviction.
• Upgrade of 10g R2 RAC to 11g R2 RAC

Confidential

AWS Cloud, Oracle & SQL Server Database Administrator

Responsibilities:

• Participate in the development and maintenance of an Enterprise Application Architecture as it relates to the Oracle Financials databases
• Ensure Oracle Application DBA team delivers on-time, on-budget, and high-quality.
• Develop and implement strong Oracle Application DBA techniques and effective methodologies.
• Perform application tuning and performance monitoring
• Managing and administering the Oracle Real Application cluster databases for better scalability and high availability.
• Database Backup monitoring and troubleshooting backup issues
• Performing and co-coordinating periodic database maintenance activity
• Migration of databases to new servers with hot and cold backup.
• Identifying Root cause for frequently occurred issues
• Troubleshooting the database performance issues such as long running queries etc
• Generating Stats pack / AWR reports in order to analyze the performance of the production databases.
• Daily co-coordinating with the Client manager with status call and giving solution for the day to day problem faced by the Business users.
• Servicing the customer’s tickets and resolve the issues within the SLA defined using BMC remedy ticketing tool
• Responsible for memory and Application tuning of the databases using the Oracle utilities like OEM, SQL Trace, TK Prof and Explain Plan.
• Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning.
• Expertise in Server Database Administration including planning, implementing, backup, and recovery strategies.
• Implemented Standby Database and Database Replication to realize database high availability. Created partitions for large table to improve performance.

Confidential

Responsibilities:

• Providing L1 and L2 production administration for Oracle databases (7x, 8x, 9i, 10g & 11g) running in Windows, Solaris, AIX, HP-UX and Redhat Linux operating system.
• Monitoring and troubleshooting issues arising in database backups taking through RMAN.
• Migration of databases to new servers with hot and cold backup.
• Generating Stats pack / AWR reports in order to analyze the performance of the production databases.
• Performed and maintaineddatabase backupsusing Enterprise Manager orRMANas well as OS utilities.
• Restore and Recover, Cloning and Duplicating databases using scripts as well as with RMAN.
• Migration: Duplicated database using RMAN and upgraded it to oracle 10g/11g and applied latest patch set.
• Schemas refresh using Export/Import. Creating the database, table spaces, tables, indexes, settings privileges and user logins for prod/dev/test databases.