Sql Server Data
Resume:
Venkat Mohan
Jefferson City, MO *****
Professional Summary
Technically sophisticated professional with nearly 9 plus years of experience in IT Industry.
* **** ***** ** ********** as Oracle Database Administrator.
9 plus years of experience as Microsoft SQL Server DBA.
7 plus years of experience in SQL, PL/SQL developer.
4 plus years of experience as SSIS Developer.
Proficient in developing Data Modelling and Database design.
Good knowledge in cloud computing which enables organizations to obtain flexible, reliable and cost-effective IT-infrastructure.
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
Proficiency in designing and Implementing the Oracle Real Application Clusters(RAC) on for an OLTP application with Transparent Application Failover.
Expertise in supporting multi node RAC cluster.
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/ ETL Developer
Extensive experience in MS SQL Server Database Administration including planning, installation, deployment/implementation, configuration as per Microsoft Operation Framework guidelines.
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.
Expert in Monitoring and troubleshooting Log Shipping.
Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and 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.
Experience in Replication – Snapshot, Merge and Transactional.
Has very good experience in complete ETL cycle including data analysis, database design, data mapping and conversion and data load.
Can work in a fast-paced environment, Good team player and can work independently. Helped the database developers on technical issues.
Experience in using Business Intelligence tools (SSIS, SSRS) in MS SQL Server 2008R2.
Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.
Proficient in Always on/ Mirroring for Disaster recovery.
Experience in Performance Tuning and Query Optimization.
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.
Expertise in MS SQL Server databases backup/restore, Disaster recovery strategies.
Planning and implementing the log shipping of MS SQL server databases, successfully configured log shipping on MS SQL server 2005/2008R2/2012.
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 application to AWS.
Ingress and egress of data to and from 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.
Knowledge on Amazon S3 static website hosting.
Good knowledge in implementing Amazon RDS’s (Oracle & SQL Server).
High-Availability, Fault Tolerance, Scalability, Database Concepts, System and Software Architecture, Security, IT Infrastructure, Virtualization, and Internet Technologies.
Technical Skills:
Languages
SQL, PL/SQL
Operating system
HP-UX, Linux, Windows XP/7/10/2003/2008/2012
RDBMS
SQL Server 2016/2014/2012/2008R2/2005, Oracle 11g/10g
Tools & Utilities
SSMS, SSMA, SQL Profiler, SSTA, SSIS, SSRS, DBCA, Export/Import, Data Pump, RMAN, ORACLE Toad, SQL developer
Professional Experience
Infocrossing Apr 2017 to Present
Role: DBA cum ETL Developer
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.
Installed Oracle software and configured Oracle databases on local storage and ASM.
Fine tuning the Oracle parameters to obtain maximum performance.
Creating User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
Implementing Oracle database backup & recovery solutions using RMAN and manual methods.
Package deployments on Dev/QA/Prod databases.
Scheduling the automated scripts using cron job.
Tuning of SQL queries using Explain Plan.
Partitioning large tables for better performance and manageability.
Configured databases for replication using Golden Gate.
Implemented unidirectional replication using Extract, Pump & Replicat process.
Applying PSU, CPU on databases using Opatch utility.
Applying Patchset using DBUA.
Configured Active data guard for disaster recovery and load balancing.
Troubleshoot the data guard issues and ensure it is always sync with the Production database.
Installed SQL Server software and databases creation as per the requirement.
Set the Auto growth on databases after deep analyzing on the transactions.
Fine tuning of database objects and server to ensure efficient data retrieval.
Used Query store to track the top most consuming regressed queries.
Use of Column store indexes for performance improvement.
Performance Tuning of SQL Server using Index tuning, profiler, DTA, DMVs.
Monitor the Page Life Expectency counter for Memory bottlenecks.
Configured always encrypted & TDE features for data security.
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 advanced features of T-SQL to design and tune T-SQL to interface with the Database and other applications in the most efficient manner and created stored Procedures for the business logic using T-SQL.
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.
Created DTS packages for transforming data from various data sources.
Discussed business requirements and mapped business needs.
Experience in writing SQL Queries and stored procedures.
Tuned SQL queries using execution plans for better performance.
Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
Environment: Oracle 11g R2/10g, RHEL, SQL SERVR 2016/2014/2012, Windows Server 2012/2008 R2, SSIS, SSRS, SQL Profiler, SQL Tuning Advisor.
HDFRL Jan 2016 to Jan 2017
Role: Sr. DBA & BI 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.
Performance Tuning of SQL Server using Index tuning, profiler, DTA, DMVs.
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.
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.
GMR Aero Technic Ltd Oct 2014 to Jan 2016
Role: Database Lead
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.
Setup and configured clustered servers, 2 node Oracle 11g R2 RAC with ASM.
Managing ASM disks, Fail groups, Disk groups.
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 Apr 2014 to Sep 2014
Role: Applications & Databases Manager
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.
Implemented Column store index on SQL Server 2014.
Managed contained databases in SQL 2012 & 2014 servers.
Enabled Transparent Data Encryption on SQL Server for data security.
Configured Always on in SQL standalone servers using WSFC feature.
Implemented snapshot & transactional replication for data transfer.
Strong expert in using SQL server profiler to capture the database work load.
Used SQL Tuning Advisor for the recommendations on top consuming queries.
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.
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 standby database and implemented Data guard.
Database backups and restores (Logical Backups, conventional hot & cold backups using shell scripts, RMAN or manually)
DB refreshes using cold backup or logical backups.
Installed Golden Gate software in Test and dev instances.
Configured Golden gate on production server.
Successfully tested initial Data load during environment build.
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.
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.
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.
Configured the mail alerts for any automated job failures.
Apply 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.
Configured Data Gard for High Availability
Troubleshooted 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.
Refresh schema using Export/Import
Mentor / Help team members for resolving various DB related issues.
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