SUMMARY

• A qualified IT Professional with 6 + years managing and working on leading edge projects that require experience on diverse systems and applications.
• Great team player with proven knowledge in IT training and education as well as experience in Oracle Database Administration/MS SQL Server/AWS; skilled in leading other system administrators on projects within a DevOps culture.
• Versatile in establishing client relationships for understanding their business processes, user tasks & goals; analyzing and defining requirements to ensure efficient and cost - effective technological solutions that meet and exceed client needs.

AREAS OF EXPERTISE

• Automation Tasks
• Linux/UNIX administration
• Systems Integration
• Oracle Performance Tuning
• Oracle 11g/12c/18c/19c Database Administration on Windows & UNIX Systems (Solaris, AIX, Linux)
• Technical Documentation
• C++, Java, HTML, Swift & PL/SQL Programming
• Shell Scripting
• Capacity Planning
• Communication skills
• Migration
• Technical Leadership
• Cloud Computing
• Teamwork
• Troubleshooting

TECHNICAL SKILLS

• SQL Loader
• ERD’s (Entity Relationship Diagram)
• Quest Toad
• Oracle RMAN
• Oracle SQL Developer
• SQL Developer
• SQL Data Modeler
• Oracle 13c/12c Cloud Control for patching automation
• AWS (EC2, S3, RDS, VPC, Subnets, CloudWatch)
• Golden Gate, Data Guard, RAC
• Virtual Box, VMware, Xen, KVM, Linux Containers
• Splunk
• Microsoft office (Suite/Project), Microsoft Visio

PROFESSIONAL EXPERIENCE

Confidential, Silver Spring MD

Oracle DBA

Responsibilities:

• Coordinate with team members to ensure releases of different applications are deployed correctly through WebLogic and that all change management processes are followed
• Supporting multiple databases for production, development, test and staging purposes on Sun Solaris and Windows environments.
• Worked on Configuring OEM 12c console and installed OEM12c agents on all different platforms using push method from console, and also using silent method.
• Configured and worked in Oracle GoldenGate installation, configuration, troubleshooting GoldenGate issues.
• Conduct knowledge transfer sessions and provide SOPs on daily maintenance routines and also Provide support to Development and QA teams on applications and database issues
• RMAN point in time recovery and Instance recovery done on 11g.
• Refreshing Dev and Test instances with data from Production on a regular basis.
• Created Database links, granted privileges, and roles to users with strong passwords.
• Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.
• Installing, configuring and maintenance of Oracle Replication Tool Oracle Golden Gate.
• Applied database patches using Opatch utility for RAC and Non RAC databases & cloning a database instances for Development and Test teams.
• Upgraded single instance 11g RAC databases to 12c RAC databases.
• Applied PSU Patches (11.2.0.3, 11.2.0.4) as a part of maintenance activity.
• Created a Clone Database using RMAN on remote Server
• Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests.
• Installation and configuration of Oracle on 2008R2/2012/2014 and latest service packs
• Run AWR and ADDM Reports to show potential performance issues within Oracle database
• Create appropriate stored procedures, functions, tables, views, indexes, constraints, and triggers
• Monitor and manage database backups and restores using native backups and third-party tools
• Performance tuning using the SQL Server Profiler/ Performance Monitor/DMVs
• Implement High Availability and Disaster Recovery using clustering, mirroring, log shipping, Always ON Availability Groups
• Implement transactional replication for reporting

Confidential, Bloomfield, CT

Oracle Database Administrator

Responsibilities:

• Perform Oracle Database tuning, performance monitoring and Capacity Planning.
• Responsible for the installation and patching of Oracle RDBMS on Linux and Windows servers while coordinating vendor on-site services
• Participate in 24x7 on-call rotation for production databases
• Work closely with application teams in troubleshooting issues, support root cause analysis and resolve issues.
• Actively involved in security administration adopting the principle of least privilege, managing default user accounts, implemented standard password security features, auditing database activity, and registering & applying security updates and Advanced Oracle security.
• Used normal import and export and also datapump import and export for exporting and importing schemas, tables, etc from one database to another.
• Configure Oracle Advanced Security on 12c databases to implement Transparent Data Encryption for tablespace, table and column levels. Also configured Redaction using OEM's Policy expression builder.
• Responsible for monitoring and maintaining security by managing roles/privileges for users of the databases.
• Have set up the cronjobs for run-alert, monitoring space, RMAN backup (level 0 and level 1) and recovery, archive log purge, deletion of archive logs and AWR reports on AIX-5.3.
• Cloned/Refreshed Oracle Databases for development and testing.
• Monitored Production Databases, performed performance tuning, added data files, resized segments, and table spaces.
• Wrote scripts for Startup, Shutdown and automation of backups
• Written scripts for Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• Installation and configuration of SQL server 2008/2012/2014 and latest service packs
• Generate daily health reports on data appliances to senior management
• Responsible for providing Database Administration support for business-critical applications in production and non-production environments.
• Maintain sound backup and recovery policies and procedures
• Apart of a team that designed an Entity relationship diagram for database.
• Installation and configuration of Oracle 11g/12c/18c/19c and creation of databases in UNIX, Linux and windows environments.
• Planned and scheduled Backup/Recovery Strategy took Logical Backups (with Export/Import Data pump utilities)
• Created primary objects (tables, views, indexes, synonyms, procedures, functions and triggers) to help application developers with the application design.
• Created & Managed Constraints, Database Access, Roles and Privileges.
• Performed database security and user administration via roles, profile, privilege, synonyms and auditing.
• Planned backup and recovery of database information. Maintained redo logs and archive them to tape.
• Monitored and troubleshoot bugs from alert log, audit logs and trace files using Toad and also Monitored database for performance and optimization using Toad.
• Performed day to day activities: Such as, daily error checks and database health monitoring of physical resources (disk space, memory, CPU, etc.). Performance parameters adjusted as needed.
• Produced backup report to ensure the backups were all successful and troubleshoot if the backup was not successful to find out the root cause of failed backups.
• Performed data transfer using Export/Import and Data pump.
• Tuned database and application performance using Stats pack, AWR, ADDM, Explain Plan and Oracle Enterprise Manager
• Experience working with AWS EC2 and S3
• Provisioned EC2 instances
• Experience in managing objects in S3 buckets
• Experience in setting up VPCs and Subnets for enterprise environments
• Configuration of the monitoring of the database using CloudWatch on AWS.
• Migration from oracle to PostgreSQL AWS RDS
• Expertise in setting up DataGuard Fail-Over/Switch-Over/Read-Only scenarios.
• Good exposure of Oracle DBA tasks like Installation, Patching, Cloning and Upgrade of Oracle Databases and Grid Infrastructure.
• Extensive knowledge of database backup/recovery strategy using RMAN and configuration of Recovery catalog for multiple databases.
• Exposure to SQL Tuning Advisor, SQL Profiles, SQL Monitoring, SQL Access Advisor, SQLTRACE tools and utilities.
• Installed Oracle 10g & 11g RAC software with ASM & OCFS2 file systems on RHEL, HP-UX.
• Experienced with Adding and Deletion of Nodes in RAC.
• Worked with Oracle Advanced Technologies like Oracle Enterprise Manager Grid Control, Oracle GoldenGate, DataGuard and Real Application Clusters.
• Setup maintenance of DataGuard for disaster recovery and reporting purpose with various modes
• Configuration of Listener and Tnsnames.
• Performed Disaster Recovery switchover and failover operations.
• Expertise in Tuning Memory, I/O and CPU Utilization, Disk Usage and Space Utilization.
• Upgrading and Migration of Oracle database to higher version and other platforms using manual method and traditional Export/Import, datapump & Transportable Tablespace (TTS).
• Good understanding of System Development Life Cycle, Automatic Undo management, RAID concepts and advanced features of Oracle 11g.
• Experience with applying security, and also quarterly (PSU & CPU) patches to the databases.
• Hands on experience with logical backups, Hot/Cold backups, Recovery, and cloning of databases using (RMAN) Recovery Manager, VERITAS Net Backup.
• Disk Space Management involving managing archives, space allocation to various tablespaces, and also capacity planning for new applications.
• Expertise in Configuring RMAN with Catalog /No catalog and worked on Point-In-Time Recovery and flashback.
• Performed database replication through Golden Gate.
• Used TKPROF utility, ASH, and Explain Plan for tuning SQL queries.
• Used Splunk db connect for monitoring database health also the standard and fine-grained audit trails, trace files, incident, alert, listener, and other logs on the operating system where the oracle database server is installed.
• Excellent analytical, problem solving, communication and interpersonal skills