SUMMARY

• 8 Years Database Administrator and 2 years Aws Cloud Solutions Architect experience in designing and maintaining highly available and secure networks in the cloud.
• Technically experienced with database management and system administration for multiple OS platforms. 2 years of Unix/Linux system Administration.
• 8 years of Database Administration Experience in with Oracle 10g/11g, 12c, RAC and DATAGARD technologies, MS SQL Server 2008/2012/2014 , Sybase ASE 15.13,15.7 Cluster Edition and Replication Server (REP) version.
• Excellent history of supporting DBMS in 0 down time environments during regular working hours as well as on standby for 24/7 Support.
• Excellent organizational development skills with comprehensive knowledge of strategic planning, organizational and project management, team building and project execution.
• Experience with Infrastructure Security processes and procedures
• High level understanding of AWS products and services.
• Experience in selecting the appropriate AWS services to design and deploy an application based on the business requirements
• Experience in Architecting and Administration of AWS services & secure cloud - based services using AWS VPC, security groups, NACL’s, Elastic Compute Cloud (EC2), Simple Storage Service(S3), CloudWatch, CloudFront, Route 53, Auto Scaling, ELB, RDS, AMI, IAM.
• Network and cost monitoring with CloudWatch, CloudTrail as well as setting up self-healing procedures
• Experience in maintenance and configuration of user accounts for dev, QA, and production servers and created roles for EC2, RDS, S3, CloudWatch, EBS resources to communicate with each other using IAM.
• Experience with windows and Linux environments/operating systems
• Experience in migration of document storage to AWS S3
• Experience in analysis, troubleshooting, investigating, problem solving, communication (oral and written).
• Good oral and written communication skills.

PROFESSIONAL EXPERIENCE

Confidential, VA

Edgar Oracle / Sybase/MS SQL Database Administrator / AWS solution Architect

Responsibilities:

• Actively participated in converting and Migration of the Sybase ASE Environments to Oracle 12c using AWS services
• Part of the Team responsible for the overall architecture of a Hybrid Cloud environment, choosing the right AWS components for the job and managing AWS assets which included VPC, EC2, S3, Route 53, IAM, RDS.
• Cost and performance monitoring of resources and applications using Aws CloudWatch, including creating alarms to monitor metrics such as EBS, EC2, ELB, RDS, S3, SNS and configured notifications for the alarms generated based on events defined.
• Designing automated backup solutions and Disaster Recovery for databases, applications and object data in S3.
• Involved in 24x7 support rotation for Production, Test and Development Databases.
• Building and configuration of the virtual data center in AWS to support Enterprise Data.
• Building servers using AWS and launching EC2 Instances, creating security groups, Elastic load balancers, auto scaling in a defined VPC
• Responsible for bucket creation, user account creation, access permissions and privileges to users as well as policies and IAM role-based policies.
• Excellent understanding of oracle SQL and how the language interacts with the database.
• Understanding of Oracle PL/SQL and how the language interacts with the database.
• Good understanding and implementation of oracle Multitenant architecture
• System and database Monitoring, administration and configuration of all environments using OEM 12c
• Converted oracle 11g standalone databases to 12c pluggable databases
• Created containers and pluggable databases for consolidation at all levels of the SDLC
• Plugged, unplugged and Moved PDBs to other CDBs
• Applied Database patches on oracle 12c
• Participated in the capacity planning and implementation of SDLC
• Participated in performance tuning ranging from system to query tuning for efficiency
• Loading data from flat files to database using SQL*Loader, External Tables.
• Implemented Secure Socket Layer (SSL) Sybase Security to Encrypt Communications Between App and DB.
• Managing Golden Gate Replication environment.
• Maintaining the Production and Development SEC EDGAR environments.
• Administering Adaptive Server Enterprise (ASE) version 15.7 Cluster Edition and Replication Server (REP) version 15.x on Solaris 10.
• Creating and Maintaining Backup and Recovery strategies using RMAN.
• Oracle and Sybase SQL programming for modification and maintenance of existing / new database objects, including stored procedures, views, triggers, tables, indexes, primary keys.
• Made optimal use of Oracle Support in resolving the SRs.
• 24 X 7 Production & Development database support and administration.
• Designed and Developed ETL jobs using Infosphere DataStage for data loads into MicroStrategy cubes
• Prepare the documents of the process (SOP) and knowledge transferring about the project to the new team members.

Environment: AWS Cloud Services, Oracle12c on Linux RHEL, Sybase ASE Sybase ASE 15.13/7, 12c OEM Grid Control, Symantec PC Anywhere, Embarcadero’s DB Artisan, TOAD for Oracle, MS SQL Server and Sybase. SQL Developer

Confidential - Atlanta, GA

Oracle Database Administrator

Responsibilities:

• Installed Oracle 11g on Linux platform using ASM.
• Installed and configured oracle 11g RAC in Test, and Production environments on Oracle Enterprise Linux 5.2, RedHat and windows
• Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.
• Implemented and managed optimum physical database design (table spaces, data files, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture
• Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests and gap resolutions.
• Successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold backups.
• RMAN point in time recovery and Instance recovery done on 11g.
• Extensive experience in RMAN recovery testing, RAC and standalone database
• Experience in setting up Oracle ASM storage for Oracle RAC databases.
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Worked on Performance tuning of Queries by maintaining indexing and use of Hints, Stored outlines, Statistics.
• Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.
• Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
• Developed compliance reports and performed auditing at higher levels.
• Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
• Applied PSU Patches (11.2.0.3, 11.2.0.4) as a part of maintenance activity.
• Refreshing Dev and Test instances with data from Production on a regular basis using export/import, data pump Utilities and RMAN.
• Performed database replication through Golden Gate.

Environment: Oracle 11g/11g RAC/10g, VMS, Sun Solaris, Windows Server 2008, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

Confidential - Charlotte, NC

Oracle Production Support Database Administrator

Responsibilities:

• Performed Database upgrade from Oracle 10g (10.2.0.2) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database.
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.
• Loading data from flat files to database using SQL*Loader, External Tables.
• Extensively used AWR, ADDM and explain plan for periodic performance tuning.
• Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 10g and 10g/11g environments.
• Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies. As well as Refreshed/cloned databases using RMAN utility.
• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.
• Used TOAD for database management.
• Made optimal use of Oracle Support in resolving the SRs.
• 24 X 7 Production & Development database support and administration.

Environment: Oracle 11.1.0.7, 10.2.0.5, RHEL 5.2, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL Developer, OEM, TOAD.

Confidential - Groton, CT

Oracle Production Support Database Administrator

Responsibilities:

• Planned and implemented physical backup (both hot and cold) & recovery procedures for the database using RMAN utility of Oracle 10g.
• Creating the users and assigning them the required privileges.
• Provided 24x7 on-call support as needed.
• Provided valuable inputs for various performance tuning issues.
• Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM. Performance Tuning of the database (Memory Tuning, I/O Tuning)
• Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK, SQL*Trace, TKPROF. Done resetting of storage parameters by series of exports and imports of tables, used conventional as well as direct path loads to upload the data into the server using SQL loader.
• Prepare the documents of the process and knowledge transferring about the project to the new team members.

Environment: Oracle 11.1.0.7, 10.2.0.5, RHEL 5.2, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQLDeveloper, TOAD