Candidates About

 

Madhu D

PROFESSIONAL SUMMARY

·         Over all 9+ years IT Experience as an Sr. Database Administrator / Golden gate Expert / AWS Architect progressively responsible positions in diversified and very large production and development environments in various domains like Telecom, Health Care, Banking and Manufacturing with database implementation in various Operating system platforms.

·         Extensive experience in Installation, Configuring, and Maintenance of Enterprise level Oracle (10gR2, 11gR2, 12c), MySQL databases.

·         Extensive in implementing and handling Replication technologies (Shareplex, OGG, Oracle Streams)

·         Experience in handling Multi-Terabyte Database migrations/Consolidations with minimum/no downtime.

·         Proficient in implementing and maintaining Oracle Engineered systems (Exadata, Supercluster).

·         Experience in coordinating and implementing Oracle Exadata / Supercluster Quarterly patching activates.

·         Experience in implementing high Availability using Oracle RAC & Veritas Cluster server (VCS)

·         Experience in troubleshooting issues related to Oracle RAC (Node Evictions, Node Reboots).

·         Experienced with all facets of Oracle DBA day-to-day activities like production, database monitoring, Backup & Recovery using RMAN, Cloning, Troubleshooting production issues, and Physical Database Design.

·         Extensive Experience in working with the Tools like OEM, AWR, ASH, ADDM Expdp/Impdp, SQL Tuning Advisor, SQL Plan Baselines.

·         Extensive Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, DST, Patch sets as per the Oracle recommendations.

·         Proficient in INDEX REBUILDING and INDEX TUNING.

·         Installed & configured Oracle Management Server (OMS) & Oracle Grid Control.

·         Extensive knowledge in maintain Oracle Cluster ware using Srvctl, Crsctl, has, Ocrconfig, Cluvfy, Private IP, public IP, SCAN IP and Virtual IPs along with NAS and SAN for ASM storage.

·         Worked extensively in Performance Tuning at various levels including instance tuning, Query tuning, Database performance tuning.

·         Worked effectively on database Server Tuning, Application Tuning, and Database Security.

·         Well experienced in managing data files, redo logs, rollback segments, stored procedures, functions, packages and Triggers.

·         Excellent knowledge of Oracle Architecture, SGA, Configuration of TCP/IP protocol, Listeners, TNSnames, SQLNET, V$ and DBA views

·         Experience in working different storage technologies (SAN/NAS, ASM, ACFS, and Oracle ZFS 7320, 7420).

·         Experience in Load and Performance testing of the database servers and application servers, analysis and documentation of results.

·         Proficient in maintaining Data Integrity, Profiles, Resources, Password Security, Users, Privileges, and Roles.

·         Working knowledge of My-SQL and SQL Server.

·         Strong skills in SQL* PLUS, PL/SQL, UNIX Shell scripts (Ksh and bash).

·         Responsible for monitoring and tuning the performance of queries and instances of production and stage databases using oracle features 10046 event trace files, hints, stored outlines etc.

·         Ability to function successfully in a highly stressful, 24x7 mission critical environment.

·         Exceptional communication and interpersonal skills. Ability to work efficiently as a part of the team and individually. Possessing excellent developmental and analytical skills.

·         Utilized oracle business intelligence Enterprise Edition (OBIEE) to support the justice officer of the chief financial officer (OCFS) financial analysts to improve the process of reconciliation and verification of financial reports.

·         Resolve connection issues for OBIEE with RAC Configuration and worked with SAP basic for BR tools, cloning of DB.

·         Experience in upgrading Oracle database from 9.2.0.6 to 10gR2 and 11g.

·         Installed and configured OBIEE, Discoverer 11g/10g with Load Balancing.

·         Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.

·         SQL Server 2014, 2012, 2008R2, 2008, 2005 and 2000.

·         Extensive knowledge of VPC architecture, EC2 formation, IAM management, S3, CloudWatch, Elastic IPs and managing securing groups on AWS.

·         Experience in the design and implementation of Continuous Integration

·         Continuous Delivery, Continuous Deployment (CI/CD), DevOps tool chain and DevOps processes for agile projects.

·         Effective combination of System, Backup & Restore, Storage Administration Automating, configuring and deploying instances on AWS cloud Environment and Data centers.

·         Design AWS formation templates to create VPC architecture, EC2s, Subnets and NATS to meet high availability application and security parameters across multiple AZs.

·         Manage migration of on-prem servers to AWS by creating golden images for upload and deployment.

·         Worked within the Cloud for integration processes.

·         Performed DevOps for Linux Mac and Windows platforms.

·         Focused on automation and integration.

·         Monitored developed applications and fixed bugs.

·         Wrote code and designed continual updates.

·         Completed load and performance testing of extremely complex systems.

·         Experienced with Interpreted Languages including Perl and Python.

·         Facility with development methodologies including Agile.

·         Excellent configuration management using Puppet Chef and Ansible.

·         Extremely knowledgeable about CI/CIT/CID integration.

 

 

CERTIFICATIONS:

Certified in Oracle 10g & 11g versions from Oracle Corporation.

Skills Overview:

 

RDBMS:                                             Oracle 12c, 11gR2, 10gR2, 10gR1, Oracle 9i.

Oracle Tools & Utilities:         RMAN, EXP/IMP, EXPDP/IMPDP, SQL * Loader, DBVERIFY, STATSPACK, AWR, ASH ADDM, OEM, ODM, CELCLI, DCLI.                          

O/S:                                                      Linux, SunOS, IBM-AIX, HP-UX, Windows 2000/XP.

Tuning Tools                                 TKPROF, EXPLAIN PLAN, STATSPACK, ORADEBUG

Automation/Build Tools        JENKINS,CHEF,ANSIBLE

Cloud Technologies                 AWS(EC2,S3,Cloud Watch,RDS,ElastiCache,IAM)

Scripting Languages                PYTHON,UNIX SHELL

 

 

PROFESSIONAL EXPERIENCE:

 

Fannie Mae,  Reston, VA.                                                                                                Apr 2017 to Till date.

Role : Sr. Oracle database Administrator with Cloud devops engineer

 

The Federal National Mortgage Association, commonly known as Fannie Mae, It is leading source of financing for mortgage lenders and our financing makes sustainable homeownership and workforce rental housing a reality for millions of Americans.

Responsibilities:

• Implementing and Upgrade advanced features of Oracle 12C such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance. 
• Monitoring & Troubleshooting Oracle error logs, Various Scheduled DBA Server Agent jobs, Maintenance plans.
• Setup and maintain all database backups for all production Oracle servers. This includes using native Rman backup.
• Have good experience in administering ASM disk Groups.
• Implemented advanced features of Oracle 11g/10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
• Responsible for all regular Database administrative activities.
• Hands on experience in installing and administering Oracle WebLogic server (10.3.6).
• Implemented Oracle Golden Gate installation, configuration, troubleshooting GG issues.
• Implemented Golden Gate Change-Synchronization and Initial-load replication processes.
• Responsible for choosing Capture and Apply methods in Oracle Golden Gate Replication.
• Responsible for creating Processes groups in GoldenGate Replication.
• Experience in installing Trigger based DDL capture.
• Expertise  Configuring the Bidirectional replication using GoldenGate
• Upgrading the database using GoldenGate zero down time migration.
• Building test strategies, backup & recovery models for Oracle. Refreshing test databases.
• Responsible for the day-to-day user requests and troubleshooting the database related problems.
• Implemented partitioning and materialized views for Oracle 10g and 11g Databases.
• Responsible for Online/Offline database backups and managing Database recovery with RMAN.
• Worked with Oracle Support during ORA-600 and ORA-7445 issues.
• Wrote scripts to improve the performance of importing indexes.
• Cloning of database for development and test environments.
• Estimate SAN storage need for replication across multiple sites.
• Implement new table partitioning technique using virtual columns.
• Support Performance testing team during weekend tests.
• Control user access and monitor space consumption.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster Recovery and Planning.
• Handling Memory configurations for SQL Server 2014 and SQL Server 2012 on Windows 2012.
• Develop test and tune database code and information.
• Design and maintain Sql scrips.
• Installation and configuration of Oracle Enterprise Manager Cloud control 12c on RHEL.
• Migrating/upgrading the database from 11g to 12c in different operating system.
• AWS POC responsible for creating and managing VPC, AIM users, EC2 instances, EBS, S3 and RDS resources.
• Manage multiple AWS accounts with multiple VPCs for both production and non-production where primary objectives are automation, build out, integration and cost control.
• Create and manage S3 buckets and policies for storage and backup purposes.
• Design roles and groups for users and resources using IAM.
• Implement EC2 backup strategies by creating EBS Snapshots and attaching the volumes to EC2s when needed.

Senior Python Developer:

• Discusses technical and design issues with other developers, managers, users or customers whenever necessary to achieve best solution
• Familiarity with Tornado, Robot test framework, Continuous Integration environment (Jenkins), SDN, network switches/routers and DevOps a plus
• Mentors and assists activities of junior developers
• Help recruit and grow development talent
• Implement or leads the implementation of complex solutions with minimal technical debt. Develop solutions that are easy to deploy, maintain, and are bug free
• Participating fully in the development process through the entire software lifecycle
• Participating fully in Agile software development process

Cloud Devops Engineer:

• Delivered Solutions to improve Cloud architecture, deployment for AWS private and public Cloud.
• Managed multiple AWS accounts with multiple VPC's for both Production and non-prod where primary objectives included automation,build out, integration and cost control.
• Worked on automation and continuous integration processes with Jenkins and chef.
• Bootstrapping instances using Chef and integrating with auto scalling.
•  Created new Chef Cookbooks and updated existing ones to automate deployments.
• Managing AWS infrastructure with automation and configuration management tools such as chef.
• Automated application packaging and deployments though Chef.
• Automated Weekly releases with ANT/Maven scipting for complilling java coding,Debugging and placing Builds into Maven Repositiory.

 

Environment: Sun Spars 5.9, IBM–AIX, Linux, RMAN, Shareplex, Golden Gate, Toad, Expdp/Impdp, Oracle 10.2.0.4, 11gR2, GoldenGate, Shell scripting, AWS(Ec2,S3,RDS, VPC, IAM),Python,Jenkins,Anisble,Chef.

 

 

 

AstraZeneca, Boulder, Colorodo.                                                                               Oct 2015 to Dec 2016

Role : Oracle Database Administrator with Devops engineer

 

AstraZeneca is a global, science-led biopharmaceutical company, manufactures innovative medicines for major disease areas including cancer, cardiovascular, gastrointestinal infection,neuroscience,respiratory and inflammation.

Responsibilities:

• Gathered the business requirements by interacting with the business users for the Points System.
• Worked on Amazon Web Services (AWS).
• 24/7 on-call production database support.
• Installation and Configurations of Oracle 12c, 11g, 10g.
• Installed Oracle 12c, 11g RAC, 10g RAC, Standby Databases for high availability and disaster recovery/reporting purpose.
• Upgraded Oracle Database from 9i to 10g, 10g to 11g.
• Applied CPU patches.
• Migration of the database from Sun Solaris to IBM AIX, Windows to Linux.
• Expertise in recovering the database. Performed complete and incomplete database recovery.
• Configured and maintained Grid Control Repository and Deployed OMS Agents on different database servers.
• Automated the nightly RMAN backups.
• Writing and modifying UNIX shell scripts, Perl scripts to manage Oracle environments and for Backend Oracle Processes.
• PL/SQL Programming.
• Developed PL/SQL scripts for Extraction, Transporting & Transforming (ETL) data from Production databases to Data Warehouse Databases.
• Using the 11g Grid control, OEM for the database tasks like adding the data file, resizing the data file, code compilation, User/Role creation and maintenance etc.
• Experience in taking backups with RMAN in both Catalog/ No catalog modes.
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
• Attended training sessions on Mongo db, Oracle 12c.
• Planning Backup/Recovery Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
• RMAN Incremental backups.
• Logical and Physical Database Design.
• Partitioning of the tables for better performance and manageability.
• Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Cloning databases using scripts as well as RMAN.
• Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers, Mat Views and Indexes on the tables.
• Enabled the audit on all the dev/test databases, analyzed and reported the audit records about the suspicious activity in the database.
• Golden Gate installation and configuration.
• Replication using Golden Gate. (schema level).
• Worked on Exadata environment.

 

• Python Developer:
• The work will involve the development of workflows triggered by events from other systems
• Develop easy to use documentation for the frameworks and tools developed for adaption by other teams
• Iterate rapidly and work collaboratively with product owners, developers, and other members of the development team
• Work closely with Teams across the BU to create comprehensive test tools and automation frameworks
• Works with other team members, including DBA's, Other ETL developers, Technical Architects, QA, Business Analysts & Project Managers
• Work directly with project owners across the business and plan, manage and execute key projects
• Follow and improve established processes for software development life cycle with an agile approach to delivery software

Devops Engineer:

• Automated the release pipeling to acheive zero touch deployments using Jenkins,Svs,Nexus and Noilo.
• Coordinate/assist developers with establishing and applying appropriate branching,Labeling/ Naming conventions using Subversion(SVN) source control.
• Used Maven dependency management system to deploy snapshot and release arifacts to Nexus to share artifacts access projects and environmnets.
• Design AWS Cloud Formation templates to create custom sized VPC,subnets, Nat to ensure

successful deployment of Web applications and database templates.

 

Environment: Oracle12c, Oracle 11g RAC, Oracle 10g RAC, Mongodb, RedHat Linux, IBM AIX, Sun Solaris, HP-UX, Windows, Shell Scripts, ASM, RMAN, OEM/Grid Control, TOAD, SQL Developer, SQL*Loader, ERWIN, Data Pump, AWS(Ec2,S3,RDS, VPC, IAM),Python,Jenkins,Anisble,Chef

Wells Fargo (Indecomm Global Services) Hyderabad, INDIA.                                     May 2013 to Dec 2013

Role : Oracle Database Administrator

Project: CBT

 

Wells Fargo is Provider of banking, mortgage, investing, credit card, insurance, and personal, small business, and commercial financial services.

 

 

 

Responsibilities:

·         Migrated single instance database to multiple instance databases using exp/imp data pump.

·         Refresh schema using export/import, Creating the database, table spaces, tables, indexes, setting privileges and user logins. 

·         Expert in Installation, Configuration and Maintenance of Oracle Standby Data Guard. 

·         Planned disaster recovery scenarios with different recovery procedures and methods like Data Guard & Standby Database. 

·         Oracle 9i/10g/11g/12c RAC, Standby Database, Clustering and Data Guard Setup, Automatic Storage Management (ASM) and Configuration and Tuning.

·         Implemented physical standby database for maximum availability using Oracle Data Guard 11g with Oracle Enterprise Manager (OEM) 12C cloud Control. 

·         Implementing 10g Data guard with one physical database.

·         Experience in configuration and administration of Data Guard (Physical/Logical standby Databases).

·         Setup RMAN solutions for all Oracle Databases -- created Rman repository, provided best practices, optimizations and data guard and cloning techniques -- restore and recovery. 

·         Implemented and maintained Oracle 11g Data Guard/standby databases for switch-over and fail-over purpose.

·         Experience in Implementation of High Availability solutions with Oracle 10g &11g RAC, Physical Standby Databases (Data Guard)  

·         Experience with supporting the Production Database with complete lifecycle including Installations, Upgrade, Patching, Cloning, Backup/Recovery, High Availability including Oracle Real Application Cluster (RAC) and Data Guard. 

·         Responsible for the installation, configuration and overall up from 10g/11gr1 to 11gr2 (10.2.0.2 to 11.2.0.2) 

·         Databases migrated to RAC for improved resiliency and performance. 

·         Security User Management, Privileges, Role, Auditing, Profiling, Authentication 

·         Creating Materialized views and Materialized View Logs for Increased Performance and Data Replication. 

·         Knowledge in Golden Gate installation & Configuration setups in both windows/Linux environments. 

·         Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning (RAC) 

·         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 (perfstat), SQL*Trace, TKPROF. 

·         Expert in Performance Tuning and Monitoring of Oracle Databases on Unix/Linux platform using database tuning, Tkprof, Explain plan, AWR and ADDM reports, Advisors as SQL Tuning, SQL Advice, Undo, Segment, MTTR, Memory. 

·         Created indexes to facilitate easy user interface implementation and tuning.

·         Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.

·         Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

 

Environment<span styl