sr. database administrator

Venkat Mohan

*****************@*****.***

Jefferson City, MO 65109

Professional Summary

* **** ***** ** ********** in IT industry having strong skills in Oracle & Microsoft SQL Server Database Administration.

Assist in designing, planning and managing the databases on Unix/Linux/Windows platforms.

Knowledge on cloud computing AWS which enables organizations to obtain flexible, reliable and cost-effective IT-infrastructure.

Exceptional communication and interpersonal skills. Ability to work efficiently as a part of the team and individually.

Ensures High availability, Data protection, and Disaster recovery for enterprise data.

Well versed with project responsibilities such as planning and implementation.

Proficient in meeting tight deadlines and adopting modern technologies.

Successfully led, executed and maintained projects with multiple databases.

Core Responsibilities: Oracle DBA

Worked with subject matter experts and project team to identify, define, collate, document and communicate the data migration requirements.

Worked with customers in gathering business requirements for data migration needs.

Expertise in supporting multi node RAC cluster.

Proficiency in designing and Implementing the Oracle Real Application Clusters(RAC) on for an OLTP application with Transparent Application Failover.

Virtuous knowledge in Oracle Golden Gate Installation, configuration & troubleshooting Golden Gate issues.

Expert in ASM Storage Management.

Planned and implemented high availability solutions using Data Guard.

Sound knowledge in DB Installation and configuration of Oracle on UNIX/LINUX/WINDOWS.

Performing and monitoring database backup using RMAN.

Database cloning using RMAN or by manual method.

Experience in database backup using Hot/Cold and Logical Backups.

Good knowledge in Installation, Upgradation, Administration, Backups & Recoveries.

Database version up gradations and Patch up gradation.

Configuring the database in archiving mode and taking hot, cold or logical backups, incomplete or complete recovery using user managed backups.

Creating and dropping users, controlling resource use with profiles, granting and revoking privileges, creating roles.

Creating tablespaces & monitoring their growth & Resize or add more data files to database or table spaces for space related issues.

Maintaining, multiplexing and mirroring data files, control files, redo log files and archived log files.

Monitoring Database Activities, Checking for Tablespace Availability, Checking the Alert Log File for errors, and monitoring the Hit Ratios.

Maintain physical and logical backups using RMAN & User Managed Backups and Recoveries.

Experience in using 10g features such as Data Pump, ASM, and AWR.

SQL Server DBA

Extensive experience in MS SQL Server (2016/2014/2012/2008 R2/2005) Databases Administration including planning, installation, deployment/implementation, configuration as per Microsoft Operation Framework guidelines.

Perform migration and testing of static data and transaction data from one core system to another.

Updating database systems by reviewing, planning, testing and installing database security patches and service packs.

Providing highly available database and application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, etc.

Expertise in MS SQL Server databases backup/restore, Disaster recovery strategies.

Planning and implementing the log shipping of MS SQL server databases.

Expert in Monitoring and troubleshooting Log Shipping.

Experience in Replication – Snapshot, Merge and Transactional.

Good Knowledge in Always on Availability group for HADR.

Familiar with the TDE & Always encrypted features.

Proficient in Always on/ Mirroring for Disaster recovery.

Experience in Performance Tuning and Query Optimization.

Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, user defined functions.

Very good T-SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands

Experience in Database backup and disaster recovery procedures.

Has very good experience in complete ETL cycle including data analysis, database design, data mapping and conversion and data load.

Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.

Experience in using ETL tools in (SSIS) MS SQL 2012/2008R2/2005.

Data Loading Experience in SQL Server 2008 using SSIS ETL and Experience in developing packages in SSIS and DTS according to task.

Data analysis and data migration by transferring them using SSIS packages.

Proficient in extracting, transforming and loading of data using SQL Server DTS and SSIS.

Monitored and modified Performance using execution plans and Index tuning.

Documentation for the Disaster Recovery plan.

Can work in a fast-paced environment, good team player and can work independently. Helped the database developers on technical issues.

Expertise in Cloud Computing(AWS)

Infrastructure (Server, Storage & Database) discovery, design, build and migration experience.

Experience with private and public cloud architectures and migration considerations.

Architectural exposure to LINUX, Apache, Windows, IIS Server and other technologies.

Making architectural decisions based on the AWS recommended architectural principles and best practices.

Extensive experience on Lift and Shift of an existing on-premises databases to AWS.

Architecting AWS service based on data, compute, database, or security requirements.

Expertise on AWS Security with AWS Identity and Access Management (IAM).

Estimating AWS costs and identifying cost control mechanisms.

High-Availability, Fault Tolerance, Scalability, Database Concepts, System and Software Architecture, Security, IT Infrastructure, Virtualization, and Internet Technologies.

Knowledge on Amazon S3 static website hosting.

Launch of AWS resources, such as Amazon EC2 instances, into VPC.

AWS - VPC, Public & Private Subnets, Route Tables, Internet & NAT Gateways.

Define network interfaces, and attach one or more network interfaces to the instances.

Users, Groups & Roles creation using Identity and Access Management.

Expertise in launching Amazon EC2 in public and private subnets.

Technical Skills

Languages

SQL, PL/SQL, shell scripting

Operating system

Unix, Linux, Windows 2012/2008 R2/2003/10/7/XP/7

RDBMS

Oracle 12c/11g/10g, SQL Server 2016/2014/2012/2008R2/2005

Tools & Utilities

DBCA, NETCA, DBUA, OPatch, Export/Import, Data Pump, RMAN, ORACLE Toad, SQL developer, SSMS, SSMA, SQL Profiler, SSTA, SSIS, SSRS

Professional Experience

INFOCROSSING, USA Apr 2017 to Present

Role: Sr. Database Administrator

Description: Encounter Data Processing System provides accurate, complete, timely reporting of encounters to CMS and allows for encounter error corrections and resubmission of the rejected encounters from CMS and WIPRO Compliance Checker. The WIPRO Web Portal provides access to all encounter data to the customer via an Encounter Management Module. The Medicare Advantage Organizations deliver their encounter data to WIPRO. The encounter data is then checked for CMS compliance prior to submission to CMS by Encounter Data Processing System. The encounter data is then submitted to CMS where it gets edited by CMS using the Common Edits Module (CEM). All encounter data, delivered to WIPRO, rejected by the WIPRO EDPS System, submitted to CMS and the CMS response is stored in the WIPRO databases. Access to the encounter data is allowed via an Encounter Management Module with dashboards and screens for inquiry, reject correction and resubmission of encounter data as part of the WIPRO Encounter Data Processing System on the WIPRO Web Portal.

Responsibilities:

Responsible for providing 24 X 7 critical production support on Oracle & SQL Server to all Production, development and clustered servers.

Working across multiple functional projects to understand data usage and implications for data migration.

Assist in designing, planning and managing the data migration process.

Involved in process improvement, Oracle Server Upgrades/Migrations/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Data Guard, Oracle Advanced Replication, Real Application Clusters, Oracle Standby Servers.

Responsible for setting and managing user accounts, Granting required privileges to users.

Applied PSU's in Development, Testing & Production Environment.

Installed, configured, and maintaining Oracle 12c & 11gR2.

Upgraded databases from Oracle 10g to 11g R2.

Moving data between databases using Data Pump.

Implemented Oracle database backup & recovery solutions using RMAN and manual methods.

Performed block recovery using RMAN.

Installed and configured Golden Gate for replication.

Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.

Tuning of SQL queries using Explain Plan.

Creating User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.

Partitioning large tables for better performance and manageability.

Configured SQL Server always encrypted & TDE features for data security.

Fine tuning of database objects and server to ensure efficient data retrieval.

Use of Column store indexes for performance improvement.

Performance Tuning of SQL Server using Index tuning, profiler, DTA, DMVs and DMFs.

Monitor and optimize system performance using SQL Profiler and Database Engine Tuning Advisor.

Designed and implemented incremental and full backups policies and procedures.

Performed database logical and physical design, maintenance, tuning, archiving, backups, replication, recovery, software upgrades, capacity planning and optimization for SQL Server database.

Used database consistency checks using DBCC utilities.

Successfully Upgraded from SQL 2008 R2 to SQL Server 2012.

Designed, implemented, configured SQL 2014 Prod/QA environment on 2 node cluster environments.

Configured SQL contained databases as per the requirement.

Setup and configured Always on / Database mirroring in High Performance, High availability mode as standard DR strategy.

Designed and deployed SSIS packages in production environment to implement business logics.

Proficient in extracting, transforming and loading of data using SQL Server DTS and SSIS.

Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers.

Interacted with the users for understanding and gathering business requirements.

Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using SSIS services.

Involved in the analysis, design, development, testing, deployment and user training of Analytical and transactional reporting system.

Experienced in writing SQL Queries, Functions, Triggers and Stored Procedures.

Used indexes to enhance the performance of individual queries and enhance the Stored Procedures.

Managed all indexing, debugging, optimization and performance tuning using SQL Profile and SQL Server Agent.

Designed, developed, and tested stored procedures, views and complex queries for Reports distribution.

Effectively used views to prevent unauthorized access.

Tuned SQL queries using execution plans for better performance.

Optimized by assigning relative weights to the tables in the Catalog and Query Performance.

Environment: Oracle 12c/ 11g R2/ 10g, RHEL, SQL SERVER 2016/2014/2012, Windows Server 2012/2008 R2, SSIS, SSRS, SQL Profiler, SQL Tuning Advisor.

GMR HDFRL, India Jan 2016 to Jan 2017

Role: Sr. DBA & Data Analyst

Description: Hyderabad Duty Free Retail Limited (HDFRL) is a 100% subsidiary of GMR Group and running Duty Free Shops at GHIAL International Airport, Hyderabad. HDFRL is a travel retail organization selling products like Liquor, Tobacco, Confectionary, Perfumes, Electronics, Super Market and Destination products. HDFRL is a custom bonded shop which caters to the needs of exclusively International Passengers at Airport.

Responsibilities:

Installation, Administration and Maintenance of SQL Server Instances.

Setup Test, Dev, Staging and Production Environments.

Running Index tuning wizard and rebuilding indexes (Clustered/Non-Clustered) for faster query response.

Implemented SQL Replication for Load Balancing.

Actively Involved in SQL Replication in sharing the access load between several databases servers having identical databases.

Worked with Transactional Replication where data changes frequently and need for constant refreshing of the data.

Involved and responsible for development of Reports using SSRS and populating the Warehouse data using SSIS.

Worked and responsible for design, implementation and enhancement of ETL jobs

Created Users and assign permissions based on the level of database access the user would need.

Created Linked Servers to SQL Servers and other databases such as Oracle.

Created SSIS packages to populate data from various data sources.

Created packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server.

Developed a Tabular Reports, ad-hoc reports using SSRS Report Designer.

Used indexes to enhance the performance of individual queries and enhance the Stored Procedures.

Managed all indexing, debugging, optimization and performance tuning using SQL Profile and SQL Server Tuning advisor.

Designed, developed, and tested stored procedures, views and complex queries for Reports distribution.

Designed database Backup and Restoration Strategy.

Monitor database Backups, which are being performed regularly.

Performing point in time recoveries, as per the requests.

Setup High-Availability as part Disaster Recovery Strategy for the Databases.

Troubleshoot various problems that arise in a day-to-day work and fix the issues.

Monitoring and Performance Tuning. Physical Server Level, Database level (Database settings and options) and query tuning.

Documenting major changes to the SQL Servers.

Apply Service Packs.

Ensuring that storage and archiving procedures are functioning correctly.

Capacity planning.

Developing, managing and testing back-up and recovery plans.

Environment: Microsoft Navision, SQL Server 2008 R2, Windows 2008 R2.

GMR Aero Technic Ltd, India Oct 2014 to Dec 2016

Role: Sr. Database Administrator

Description: MRO facility is to provide full Aircraft base maintenance service infrastructure in India, and will cater to the maintenance needs of the regional and global Airline customers. MRO was formed to develop an integrated, best in class third party airframe Maintenance, Repair & Overhaul (MRO) facility at the Special Economic Zone within Rajiv Gandhi International Airport (RGIA), Hyderabad.

Responsibilities:

Installing & configuring Oracle cluster ware & Database Software.

Develop best practice, processes, and standards for effectively carrying out data migration activities.

Prepare data migration plans including migration risk, milestones, quality and business sign-off details.

Installed Oracle cluster ware & Database Software.

Implemented 2 node Oracle 11g R2 RAC with ASM.

Managed ASM disks, Fail groups, Disk groups.

Configured ADVM on ASM disk group volumes.

Build ASM Cluster file system on ADVM’s.

Managed database backup using RMAN.

Performed Full/ Level 0/ Level 1 cumulative & incremental backups.

Familiar with the Cold & Hot backups.

Identify the block corruptions and perform block recovery through RMAN.

Performed logical backups using data pump.

DB refresh on development boxes for the developers testing.

Data guard Implementation with high performance mode for DR.

Configured Golden Gate to achieve unidirectional replication.

Successfully tested initial Data load during environment build.

Cross-Train DBAs on Golden gate configuration and replication.

Performed database management functions such as maintenance, access issues and security.

Conducted designing, assembly and tuning of databases in coordination with development teams.

Evaluated database performance for investigation of issues and further resolution for efficiency.

Migrated Non ASM databases to ASM.

Experience with High Availability features (RAC/ DG/ ASM / Flashback / RMAN).

Worked with on RAC resolutions on hang check timer, split brain, RAC recovery, ASM, OCR corruptions, Voting disk loss.

Troubleshoot performance issues for the RAC instances (GC events)

Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle cluster ware).

Environment: Oracle 11g R2, RHEL 5.4

GMR Hyderabad International Airport Ltd, India Apr 2014 to Sep 2014

Role: Database Administrator

Description: Created and maintained small mid-sized databases for hosting various in-house developed applications. One among them is E-Boarding Project, First Indian Airport to go live on E-boarding facility for all domestic passengers. Developed in-house, the E-boarding Solution by GMR Hyderabad International Airport Ltd is the first end-to-end e-enabled boarding solution. The E-boarding solution at RGIA is quite unique as it fully eliminates the need to manual stamping of boarding cards even for physical boarding cards issued by CUSS (Common Use Self Service) machines or the check-in counters. Further, it covers end-to-end all the key passenger processes at the airport viz. starting from entry to terminal and including check-in, security check, boarding gate and finally the boarding bridge check before entering the aircraft.

Responsibilities:

Installed and administered SQL DB 2014/2012/2008/2005 a two-Node Cluster Active-Passive on Microsoft Windows Server 2012/2008 Enterprise Edition on SAN environment.

Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.

Experience in creating database Objects like Tables, Stored Procedures, Views, Triggers, user defined data types and functions.

Responsible for day to day tasks like re-indexing, checking integrity, backup and recovery.

Experience with T-SQL (in writing procedures, triggers and functions)

Configured Log shipping for High availability.

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Rebuilding / Monitoring the indexes at regular intervals for better performance.

Developed and implemented SSIS 2008 ETL processes to load data from source files to target tables.

Created complex SQL views and stored procedures to join multiple tables for contract data interface files.

Created SQL Server audits and policies to monitor activity on SQL databases to ensure databases were in compliance, and met the Service Level requirements of our clients.

Scheduled full, differential, and transactional log backups for user created databases in production environments.

Responsible for setting up security, and providing user access to SQL Server instances and objects.

Optimized T-SQL query performance using SQL Profiler, Execution Plans, and DMV's.

Assisted our development team with writing effective T-SQL stored procedures and views.

Responsible for setting up SQL Server jobs to monitor disk space, CPU activity and Index fragmentation.

Configured Log Shipping, Database Mirroring, always on strategies to support HADR.

Data Design and Development on Microsoft SQL Server 2012/2008R2/2005, T-SQL, Performance Tuning, Troubleshooting, SSIS/DTS Package Configuration, SSRS.

Creation of user databases, users and assigning roles to the users.

Providing Security by giving access permission to users at various levels.

Backup’s validation by restoring it in a development instance.

Monitoring jobs and generating reports with logs generated.

Participated in weekly status meetings.

Proactive Monitoring of database critical parameters for Database Servers.

Meticulously work with the development team to improve the application performance by database fine tuning.

Environment: SQL Server 2014/2012/2008/2005, Windows Server 2008/2003.

Reliance Fuel Farm, India Oct 2012 to Mar 2014

Role: Database Consultant

Description: Fuel Farm application (Fuel handling system - FHS) automates the dispensation of aviation fuel from the fuel farm plant to all the dispensation units at the aircraft bays.

Responsibilities:

Installation of Oracle Software and Database creation.

Created physical standby database and implemented Data guard.

Configure Maintenance jobs for the databases.

Database backups and restores (Logical Backups, conventional hot & cold backups using shell scripts, RMAN or manually)

Implemented Oracle database backup & recovery solutions using RMAN and manual methods.

DB refreshes using cold backup or logical backups.

Configured Golden gate on production server with zero downtime.

Successfully loaded the initial Data using data pump.

Setup Golden Gate User with necessary privileges.

Cross-Train DBAs on Golden gate configuration and replication.

Performed DBA day-to-day activities like monitoring space availability, adding data files, user security.

Applied patch set 10.2.0.5 on 10.2.0.3.

Maintaining history of backups using documentation.

Proactive monitoring of backups.

Support 24x7 operations for Production/Dev/UAT databases in Onsite/Offshore working model and ensure 100% uptime of IT Infrastructure for Clients.

Analyze and troubleshoot failed backups.

Experience of monitoring and rebuilding indexes and analyzing very large tables.

Database reorganization and Database Shrinking.

Applying of Critical Patch Updates, PSU’s.

Fixing Oracle Database and OS alerts, debugging ORA errors, resolving database related issues faced by application users.

Environment: Oracle 10g, Windows Server 2003.

GMR Hyderabad International Airport Ltd, India Nov 2007 to Sep 2012

Role: Application & Database Administrator

Description: Airport Operation Database is a central database which is integrated with many IT systems like the Flight Information Display System (FIDS), FBLB, ATC, Staff Pages, BIDS through WebSphere middleware (integration broker) with concurrent users.

Responsibilities:

Provided 24/7 Database Administration support for the Airport Databases on which critical airport applications are operational.

Responsible providing 24x7 on-call production/development/testing database support.

Involved in installation of Oracle on different platforms, loading of user data to reproduce the problem.

Applied Oracle patches to production/Quality/development instances.

Managed database backup using RMAN.

Involved in Weekly Database refresh from production to quality.

Supported Oracle DB backups (hot/cold), logical backups.

Setup classic capture replication mechanism using golden gate.

Troubleshooting archive log transport failures for standby database.

Created the database, tablespaces, tables, indexes, settings privileges and user logins.

Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactive.

Performed DBA day-to-day activities like monitoring space availability, adding data files, user security.

Provided technical support for Oracle Server to customers for Production Database.

Supported customers to manage their operational data ranging from GB to TB in Oracle database, solving space allocation issues.

Configured Active-Active, Active-Passive & standalone SQL Servers.

Configured DB Mirroring for disaster recovery.

Installed service packs on SQL Server.

Scheduled automatic backups and monitor them on regular basis.

Performance tuning and diagnosing the issues using DMV’s.

Checkout the fragmentation and reorg/ rebuild indexes online.

Workload capture using SQL profiler and implementing the recommendations.

Used perfmon to monitor the real-time data.

Mentor / Help team members for resolving various DB related issues.

Support 24x7 operations for Production/Dev/UAT databases in Onsite/Offshore working model and ensure 100% uptime of IT Infrastructure for Clients.

Incident/ Change/ Problem Management using BMC Remedy.

Alert monitoring using BMC.

Preparing SOP Documents

Analyzing and implementing the Disaster Recovery Trial.

Environment: Oracle 10g, HP-UX, SQL Server 2005, 2008 R2 Windows Server 2003/ 2008.

Education

Electronics and Instrumentation Bachelor of Engineering from Jawaharlal Nehru Technological University, Andhra Pradesh in 2002.

Contact this candidate