PROFESSIONAL SUMMARY:

• Experienced IT professional managing Oracle (8i, 9i, 10g, 11g, 12c), Oracle Database Appliance (ODA X3 - 2, X4-2, X5-2), MongoDB (3.2.x,3.4.x), Microsoft SQL Server (2005, 2008, 2012, 2014, 2016), MySQL (5.0,5.1,5.5,5.6.5.7), DynamoDB, Azure SQL Datawarehouse and Redis clustered database systems in a variety of production and development environments including on-premise and cloud based deployments (Amazon Web Services)
• Strong Oracle experience including installation, ODA, RAC, Dataguard, implementation, configuration, performance tuning, patching and cloning as well as upgrading and migrating on and to a variety of platforms.
• MongoDB experience including installing two shards with three nodes replicas, OpsManager, Head DB snapshots to S3 buckets using OpsManager, Security features implementation (KMIP, SSL, Audit, LDAP) and performance tuning
• Microsoft SQL Server experience including installation, patching, backup and recovery, capacity planning, performance assessments, data migrations, refreshes, SQL Server Clustering, always on availability groups, SQL queries, tuning and report writing.
• Extensive experience in Oracle data management, data movement and migration using Data Guard, export/Import, cloning, SQL Loader as well as Data Pump utilities.
• Proficient in database backup and recovery methodologies, Active Data Guard, physical (Hot/Cold) backups using RMAN and Logical (Data Pump or regular Import/Export) backups, as well as manual methods.
• Strong knowledge of Oracle cloning using RMAN and/or SAN technologies.
• Data Warehouse experience including Informatica ETL development and Informatica administration
• Development experience utilizing various languages
• Exceptional communication skills and customer service orientation.

SKILL:

Oracle Database Administration (8i through 11g and 12c), Oracle Database Appliance (ODA X3-2, X4-2, X5-2), RAC, ASM, Active Data Guard, ACFS and file systems

Mongo NoSQL database administration on AWS EC2 cluster using OpsManager

Microsoft SQL Server Database Administration (2008,2012,2014,2016), clustering, always-on availability groups

MySQL Percona cluster administration and HA proxy

Oracle, Redis, SQL Server on AWS EC2 instances and MySQL on AWS RDS

Azure SQL Datawarehouse setup with new AD user account, roles, and privileges

Proficient with various operating systems (Red Hat Linux, AIX, HP, UNIX, Open VMS, Windows)

Database Tools (SQL, T-SQL, SQL Plus, SQL Developer, Toad, MongoDB Compass, Opsmanager, mongotools)

Development and automation using PHP, C++, XML, PowerShell, Python, Amazon AWS (EC2,RDS,DynamoDB,S3), AWSCLI

Informatica ETL development and Informatica administration (9.0.x and 9.5.x)

WORK HISTORY:

Sr. Database Engineer

Confidential, Tempe, AZ

Responsibilities:

• Responsible for the comprehensive administration of all database systems including Oracle 11G, 12C RAC with dataguard, MongoDB 3.2,3.4 with sharding and replication on AWS EC2 servers, Microsoft SQL Server 2012,2014 and 2016 clusters, DynamoDB, Redis and MySQL clusters on premise and in cloud.
• Oracle Database Appliances (ODA) X3-2, X4 and X5 with bare metal 2 nodes servers, Used OAKCLI to patch ODA servers (Infrastructure, Grid (GI) and Oracle Database patches)
• Used ILOM (Integrated Lights out monitoring) to administer ODAs, to Re-Image ODAs, to generate snapshots files for Oracle support to diagnose the issues
• Implemented Oracle on AWS EC2 Servers: Oracle Grid software installed, formatted EBS volume disks, created ASM with disk groups, installed Oracle database software and created Oracle database instances
• Installed MongoDB with two shards, Replication set with three Replication factors in each shard, three Config servers, six mongos servers on AWS EC2 servers. MongoDB HeadDB snapshot backup to AWS S3 storage via Opsmanager
• Deployed OPSManager with five opsman servers and two ops man servers dedicated for Backup and Restore
• Enabled audit features, SSL authentications, KMIP (Gemalto third party) for encryptions in MongoDB
• Created and maintained a Central Management Server in AWS to be used to backup/restoration, monitoring, and auditing processes for SQL Server environment
• Diagnose server and database issues while maintaining high availability of MS SQL Clusters
• Completed a migration of all SQL Server assets from on-prem data center to AWS with little to no downtime
• Deployed high availability clusters in AWS utilizing Always-On Availability Groups and Windows Server Failover Clustering (WSFC)
• Designed and implemented backup and restoration procedures in on-prem data center and transitioned them to WSFC clusters in AWS
• Worked with Data Warehouse team to deploy SQL Data Warehouse in Azure while maintaining full compliance with SOX and FTC requirements
• Architect database migration from on-premise to AWS EC2 and RDS.
• Implemented Percona mysql cluster with 3 node master instances, prepared audit hardening documents and configured security settings, generated quarterly audit reports for internal and external audits
• HA-Proxy configuration to route the connections from applications to mysql cluster instances
• Implemented AWS RDS mysql instances with Replica setup, backup jobs scheduled, configured monitoring alerts settings
• Basic administration experience of multiple PostgreSQL Databases
• Clone and/or refresh development systems from production as necessary. Currently from on-premise to AWS.
• Guarantee disaster recovery for all database systems.
• Develop and automate administrative tasks using PowerShell and Python interfacing with on premise systems and AWS cloud technologies. Wrote and automated data extraction between AWS DynamoDB and Oracle saving approximately 260 man hours a year.
• Evaluate current processes and use either Python or UNIX shell scripting to automate tasks wherever possible. Developed a Python program to access all MySQL servers on premise and in AWS, extract all security information and create individual Excel files for submission for internal audit.
• Test and verify major production changes utilizing DR site and Oracle Snapshot Standby.
• Review and tune SQL queries using Toad, OEM and RDBMS expertise.
• Upgraded Informatica environments from 9.0.1 to 9.5.1 with LDAP settings
• Requirements gathering, Business Analysis and analyzed the functional specs provided by the ETL Architect and created technical specs documents for all the mappings.
• Designed and developed ETL strategies and Mappings from source systems to target systems
• Achieved compliance with SOX and FTC audit requirements for database environments containing financial data and customer PII data
• Participate in technology stack on-call rotation which rotates responsibility for the administration of Microsoft SQL server, Oracle 12c RAC, MySQL (Percona clusters), MongoDB and Redis databases.

Sr. Database Administrator

Confidential - Arizona, Phoenix

Responsibilities:

• Assure availability, recoverability and overall performance of Oracle (9i, 10g, 11g) database instances spanning various operating systems (Windows, Linux, HP, AIX, Open VMS) and RDBMS feature sets (RAC, Data Guard, stand alone etc. ) using ASM or file systems.
• Clone or duplicate database environments as necessary.
• Write UNIX shell scripts or PowerShell to automate routine tasks .
• Provide developer support at the database level, as well as assist and mentor report writers on SQL and data access.
• Assist in designing and developing data models for custom applications and data warehouse projects.
• Provide database expertise for projects relating to reducing MTR during upgrades and migrations.
• Recommend and initiate best practices to existing database systems working under production change controls.
• Assess newly acquired client environments for best practices and implement changes as necessary.
• Oracle RAC monitoring, tuning, troubleshooting and load balancing
• Streams Replication and Advanced Queuing setup and maintenance to replicate from new environment to old environment
• Upgraded database from Oracle database server 9i to Oracle database server 11g.
• Converted logical data model into physical database design
• Security implementation (VPD, FGA and DBMS CRYPTO), Roles, Trigger and auditing.
• Defragmentation of tablespace internal fragmentation using Shrink method, moving objects, rebuilding indexes and re-organization of tables.
• Designing and implementation of database backup strategy and perform full, incremental backups using RMAN with Veritas Net backup environment.
• Identifying Informatica performance bottleneck and implementing the solutions to improve the performance.
• Informatica administration with User management, scheduling workflows and monitoring workflows.
• PL/SQL coding and triggers for auditing, archiving of data and reporting purpose.
• SQL tuning using Explain plan, ADDM, SQL Tuning Advisor and SQL Profiler.
• Clone/Refresh of Testing and development database with Production database.
• Identifying stale statistics, collecting statistics and creating indexes to improve the performance of the query.
• Coordinating with Platform service and Business team for Database maintenance activities.
• Used Toad, Oracle 10g Grid control, ADDM, AWR, ASH for monitoring, performance tuning and administration.
• Participate in on-call rotation using Remedy as a help desk system.

System Analyst

Confidential

Responsibilities:

• Supported and assisted a team of DBA's in up-gradation of databases from 9i R2 to 10g R2. The role involved in installation, configuration & up-gradation of oracle server software
• Supported 2 nodes RAC environment with ASM using OEM Grid Control, Toad and SRVCTL.
• Configured High Availability with Dataguard and maintained Standby servers
• Setup/configured oracle RMAN for database backup and recovery. Applied different recovery procedures for complete and incomplete recoveries depending on the type of failure by using export/import & o/s scripts like shell & korn scripts
• Converted business requirements into logical model and logical model into database physical design.
• Advised developers confidently using Explain plan, TKprof and identifying the Execution plan in tuning queries, using Indexes, partitioning, hints etc
• Assisted few developers in writing effective SQL and PL/SQL to create stored procedures, functions, Packages and triggers
• Cloned the instances from production to Test, Development instance to test & simulate few technical challenges, coordinate with testing and development teams
• Performed daily alert log files, trace files check, and general data consistency & data integrity check
• Database backup using RMAN and Veritas Net Backup.
• Checked the configuration and performance of the existing databases including data file allocation, index, fragmentation and the impact on system performance. Analyzed potential problems (response delay, locking, server down time, etc) and avoided it
• Used Oracle 10g Enterprise Manager db console tools such as ADDM, AWR for diagnosing & monitoring events, jobs & performance related problems
• Designed and developed Daily Schema Change Monitoring program across all Databases
• Designed and developed Unix shell scripts to automate wide range of tasks including administration, backup, monitor, troubleshoot database issues, execute background and batch process round the clock

Programmer

Confidential

Responsibilities:

• Experience in Oracle Database Administration(8i,9i)
• Extensive use of SQL*Loader to enable data migration into Oracle Database
• Monitoring the database, addressing the alerts and taking necessary steps
• Web application development using PHP and HTML
• Implementation of a backup and restore procedure for the database
• Monitoring, Tuning and Troubleshooting Databases and SQL queries
• Coordinate with Application development team and assess the performance of the application in development phase before it would be moved to production phase
• Preparing periodical reports about the activities done/changes made in DB to my immediate superiors and keep them informed
• Extensive Experience in SQL and PL/SQL programming
• Handling day-to-day database activities
• Assisting developer and other teams regarding database/Oracle questions
• Recovery of database / objects whenever situation warrants