SUMMARY

• Overall, 11 years of IT industry experience in Database administration (19c/18c/12c/11g/10g/9i), AWS Cloud and system administration in various platforms like Linux 4/5/6/7, HP - UX 11.x, SOLARIS 9/10 and Windows 2008/12/14.
• Experienced in Installing, maintaining Standby DR servers using Data guard
• Successfully implemented Physical and Logical standby database using Confidential Data Guard feature for High availability configuration.
• Expertise in Amazon AWS Cloud Administration which includes services like: EC2, S3, EBS, VPC, ELB, AMI, SNS, RDS, IAM, Route 53, Auto scaling, Cloud Front, Cloud Watch, Cloud Trail, Cloud Formation, OPS Work, Security Groups
• Unix Shell scripts for hot backups, SQL*Loader, export and import of database.
• Perform Daily Monitoring of Confidential instances using Confidential Enterprise Manager (OEM), AWR, ASH, ADDM, TOAD, monitor users, table spaces, memory structures, rollback segments, logs, and alerts.
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Expertise in design and development of the three layers (Physical/Business Model and Mapping/ Presentation) of an OBIEE Metadata Repository using Confidential BI Administration Tool.
• Highly skilled at configuring OBIEE Metadata Objects including repository, variables, interactive dashboards, and reports.
• Expertise on using Amazon AWS API tools like: Linux Command line, puppet integrated AWS API tools.
• Experience in using Data warehousing tools like Informatica for ETL process
• Drawing on Experience in all aspects of analytics/data warehousing solutions (Database issues, Data modeling, Data mapping, ETL Development, metadata management, data migration and reporting solutions) I have been key in delivering innovative database /data warehousing solutions to the Retail, Pharma and Finance Industries.
• Hands on experience on Tableau Desktop versions, Tableau Reader and Tableau Server.
• Python 3.x development in Object oriented programming as well as ad-hoc scripting.
• Developed Python ETL services to for data loading, file parsing and capturing audit data.
• Skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One - off Patch) using Ansible/Python/Shell Scripts
• Security management for database, network, and operating systems.
• Good experience with automated build and deployment tools (Udeploy, Jenkins and GIT)
• Experience with FTP, SFTP, SCP files on cross platforms
• Expertise in loading data from flat files, Excel using external tables, SQL*LOADER.
• Provide 24x7 production supports as on call DBA.

TECHNICAL SKILLS

Programming Lang.

• C, C++, JAVA, Visual Basic 6, HTML
• Shell Scripting, VBScript
• PL/SQL
• Python
• Ansible

Databases

• Confidential 12c,11g,10g R2, 9i
• MS SQL Server 2012, 2008
• MS Access
• Sybase
• Mongo DB
• PostgreSQL

Operating systems

• Redhat Enterprise Linux 4.x/5.x/6.x/7.x
• Unix, Solaris, HP-UNIX
• Windows Server 2012/2008/2003/2000

Middleware

• Confidential Application Server 9iAS/10gAS, Web Logic Server 11.1.1.4

Cloud Technologies

• Azure
• AWS

Tools:

• Confidential Enterprise Manager
• MS SQL Server Enterprise Manager
• SQL*Loader, SQL*Net, SQL*Plus,
• RMAN
• Data Guard
• GoldenGate
• PL/SQL Developer, Developer 2000
• TOAD
• ERWIN Data Modeler
• Imp/Exp Data Pump, DBCA
• Splunk

PROFESSIONAL EXPERIENCE:

Confidential, Windsor, CT

Architecture Senior Advisor

Responsibilities:

• Successfully migrated dozens of servers and applications according to HIPPA
• Collaborated with IT people in regards to networking and application issues
• Owned and drove the resolution process for applications issues, communicating the statuses, performing root cause analysis, and providing post-resolution reporting for high severity incidents. Helped resolved windows login issues, isolated missing web reporting data and correct daily reporting process errors.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Analyzed the data and developed Logical Star Schema model with consultation from Data Modelers and Business Analysts.
• Developed metadata repository using OBIEE Administration tool in Physical, Business Model and Mapping, and Presentation Layer.
• Created security settings in OBIEE Administration Tool and set up groups, access privileges and query privileges and also managed security for groups in Answers.
• Involved in ETL Development using native Confidential tools (SQL*LOADER, Confidential PL/SQL, Informatica).
• Designed, developed, and tested the ETL strategy to populate data from multiple source systems.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and drop-down menu option and Parameters using Tableau.
• Hands-on experience with SQL queries including troubleshoot SQL queries and analyzing AWR data or other database log files
• Developed Rest API to processes the data from DB to another Rest Service.
• Coordinated development team with business users for system deployment and modifications
• Created monitoring, automation, metrics and utility scripts using Korn Shell, Perl, Confidential
• Provided root cause analysis for all P1/M1/M0 issues assigned and worked with development teams to fix issues.

Environment: Confidential 11g/12c/19c, AWS, OBIEE, Informatica, Perl, PL/SQL, Tableau

Confidential, Windsor, CT

Cloud Engineer

Responsibilities:

• Manage Amazon Web Services - ELB, EC2, S3, RDS, SNS, Cloudwatch
• Expertise in architecting secure VPC solutions with the help of Network ACLSs, security groups, public and private network configurations.
• Create S3 buckets and also managing policies for S3 buckets
• Experience in managing and maintain IAM policies for organizations in AWS to define groups, create users, assign roles and define rules for role-based access to AWS resources
• Create snapshots and amazon machine AMIs of the instances for backup and creating clone instances
• Used JIRA to track issues and Change Management.
• Provide technical support by troubleshooting day-to-day issues with various servers on different platforms.
• Integrated BI Publisher with OBIEE to build reports in word, excel and doc format.
• Involved in Design, analysis, Implementation, Testing and support of ETL processes for Stage, ODS and Mart.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Involved in designing and deploying a multitude application utilizing almost all of the AWS stack (EC2, Route53, S3, RDS, Dynamo DB, SNS, SQS, IAM focusing on high-availability, fault tolerance and auto-scaling
• Queried MYSQL database queries from Python using Python-MYSQL Connector and MYSQL DB package to retrieve information.
• Developed Python Modules for Ansible Customizations.
• Used Ansible Playbooks to setup Continuous Delivery (CD) Pipeline. Deployed micro services, including provisioning AWS environments using Ansible Playbooks.
• Wrote Python Code using Ansible Python API to Automate Cloud Deployment Process.
• Created AWS Route53 to route traffic between different regions.
• Created S3 backups using versioning enable and moved objects to Amazon Glacier for archiving purpose.
• Experience with monitoring tools such as Cloud Watch.
• Drive Cloud DevOps initiatives with Cloud Operations team and Customer stakeholders
• Work with IT DevOps team to migrate specific services and applications from on-prem to AWS

Environment: ELB, EC2, S3, RDS, SNS, Cloudwatch, Route53, Dynamo DB, SNS, SQS, IAM, JIRA, Chef, Puppet, UNIX, Shell Scripting, Python

Confidential, Windsor, CT

Database Administrator Senior Advisor

Responsibilities:

• Participated in upgrading Confidential database from 11.2.0.3 to 12.1.0.2 and 12.1.0.2 to 19c.
• Performed database migrations and upgrades on the same platforms and across platforms
• Installed, created and administered Automatic Storage Management (ASM) instances for use with both single instance and RAC setup (6 node).
• Tuned the RAC database and Non RAC databases for performance issues using AWR/ADDM/ASH/SQL Perf Monitoring reports.
• Applying upgrade patch, maintenance and interim (Opatch) patches on all the databases.
• Worked with the database sizes ranging from 50TB - 300TB and the number of databases are 1300+
• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Solving performance problems with the databases with respect to SQL tuning, DB parameters tuning, OS level, storage and network level Issues.
• Developed the process to install/upgrade the databases and patching activities every quarter using Ansible.
• Formulated Backup strategies & performed numerous Recovery operations. Methods include cold, hot, Recovery Manager (RMAN), Flashback Technology (FRA) and logical backups using Datadomain or Avamar.
• End to End application development right from ingesting the data feeds from upstream, Extraction, transformation and loading, Data enrichment (ETL) using PL/SQL and python.
• Performed tuning of ADHOC queries using various tools like explain plan, SQL TRACE, events like 10046, 10053 and 10060, TKPROF, UTLXPLP, UTLXPLS, DBMS STATS, ADDM and OEM.
• Installed and configured OEM grid control and intensively used Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM grid control.
• Written PL/SQL Stored Procedures, Packages, Functions and Triggers.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Designed backup and recovery procedures for OLTP system. Conducted periodic cold and hot backups.
• Participated in all phases of the system development life cycle (SDLC) from requirements analysis through system implementation.
• Worked on certifying newest versions of TIVOLI/Splunk/UIM monitoring or alerting for Confidential databases including RAC, NON RAC RDBMS and ASM.
• Used Confidential Enterprise Manager (OEM) for different DBA activities on daily basis.
• Good experience working with various FTP protocols like FTP, SCP using SSH protocol.
• Provided 24x7 on-call support for OLTP/data ware house databases and disaster recovery efforts.

Environment: Confidential 11g/12c,19c, PostgreSQL, AWS, Python, Ansible, RHEL 5/6/7, RAC, DATA Guard, Golden Gate, TOAD, SQL Developer 2.1, Putty, RMAN, AWR, ADDM, Data Pump, ASM, OEM, Splunk

Confidential, Minneapolis, MN

SENIOR Confidential DBA

Responsibilities:

• Installation, Configuration and Administration of Confidential 11g database.
• Configuring Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Build 2 Terra Bite Data Warehouse on 11gR2 RAC (2 node) with ASM on UNIX platforms
• Participated in migrating Confidential database from Windows 2003 Environment to RHEL Environment and then Participated in upgrading Confidential database from 10.x to 11.x
• Responsible for allocating system storage and planning future storage requirements 10gigabyte- 45terrabyte for the database system.
• Performance Tuning of Databases, Confidential instances, and Applications. Finding Performance bottlenecks using STATSPACK, UTLBSTAT, UTLESTAT, ESTIMATE, ANALYSE, EXPLAINPLAN, SQLTRACE and TKPROF.
• Written UNIX Shell scripts to Monitor activates like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding
• Worked on testing, pre-production stages of RAC implementation on UNIX.
• Created, upgraded, and cloned Confidential databases for Development and testing databases.
• Worked in Tuning OS, Shared Pool, Buffer Cache, and Redo Log Buffer.
• Installed and configured OEM Grid Control and intensively used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.
• Applied security related CPU and One-off patches using Opatch utility in RAC environment using rolling upgrade.
• Created materialized views for daily refreshed after ODS refreshed.
• Worked on certifying newest versions of TIVOLI monitoring / alerting for Confidential databases including RAC, Non RAC RDBMS and ASM.
• Schedule jobs in Crontab including RMAN backup, Move LOGS and other memory maintenance, security jobs.
• Controlling and monitoring of user access to the database including Granting and revoking of privileges and roles and table space quotas.
• Created users, roles and granted privileges according to the business requirements.
• Supporting both production and development activities. Worked with the databases sizes ranging from and the number of databases are 84.
• Involved in designing new structures/procedures/views/functions for development and data migration from production to reports.
• Successfully providing 24x7 supports for production, development, and test database.

Environment: Confidential 11gR2, RHEL 5.5/5.7, WINDOWS 2003, 2008, RAC, TOAD 11.x, SQL Developer 2.1, Putty Connection Manager, OEM 11g

Confidential, Minneapolis, MN

Responsibilities:

• Responsible for Confidential 11g logical and physical databases design, implementation and maintenance on UNIX.
• Supported an environment consisting of 11g RAC and standalone databases on UNIX
• Worked on Confidential configuration and Performance Tuning
• Extensively experienced in Confidential Database monitoring and Tuning using GRID control/ Confidential Enterprise Manager (OEM) monitoring.
• Installed, upgraded and patched Confidential software. Setup brand new machines including Confidential software installation, Confidential side configuration, third party backup software Legato troubleshoot and backup testing.
• Developed some Shell scripts to automate database operation and database monitoring.
• Developed or modified some Confidential backup and recovery scripts. Used Confidential backup utility RMAN to implement Confidential backup and performed a number of times of disaster recovery.
• Implemented database refresh with the hot backup using DUPLICATE or full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Performed database tuning using Explain Plan, hints, utlbstat/utlestat, Toad, AWR, ADDM and Enterprise Manager.
• Provided on-call production database support. Moved database Schema changes to stage or production. Installed and setup replicated instance of Confidential database for supporting Internet application and reporting.
• Utilized various options available in exp, expdp and imp, impdp
• Designed and architected database server for higher availability, performance and capacity.
• Designed and developed data model for application enhancements.
• Re-organized database and re-architected application server to resolve performance issues.
• Coordinated with System administrators, application developers, DBA team players before Applied Opatch in 11g.
• Monitored database and application, tuned SQL queries, indexes, Confidential initialization parameters, and clustered application servers.

Environment: Confidential 11gR2, HP-UX 10.x/11.31, RAC, DATA Guard, TOAD 11.x, SQL Developer 2.1, Putty Connection Manager