SUMMARY:

• Technically sophisticated professional with nearly 9 plus years of experience in IT Industry.
• 9 plus years of experience as Oracle Database Administrator.
• 9 plus years of experience as Microsoft SQL Server DBA.
• 6 plus years of experience in PL/SQL & 4 plus years of experience as SSIS Developer.
• Proficient in developing Data Modelling and Database design.
• Good knowledge in AWS 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.
• Proficiency in designing and Implementing the OracleReal Application Clusters(RAC)on for anOLTP applicationwith TransparentApplication Failover.
• Expertise in supporting multi node RAC cluster.
• Virtuous knowledge in Oracle Golden Gate Installation, configuration & troubleshooting Golden Gateissues.
• 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.
• 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.
• Launch ofAWSresources, such as Amazon EC2 instances, into VPC.
• AWS - VPC, Public & Private Subnets, Route Tables, Internet & NAT Gateways.
• Assign static private IPv4 addresses to the instances that persist across starts and stops.
• Assign multiple IP addresses to instances
• Define network interfaces, and attach one or more network interfaces to the instances.
• Change security group for the instances while they're running
• Add an additional layer of access control to your instances in the form of network access control lists (ACL).
• 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.
• Creating customized AMI’s and generate automated scripts using user data.
• Implementation of CDN using cloud front for a better performance and keep lower latency.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL

Operating system: HP-UX, Linux, Windows XP/ 7/10/2003/2008/2012

RDBMS: SQL Server 2014/2012/2008 R2/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:

Confidential

DBA cum ETL Developer

Responsibilities:

• Responsible for providing 24 X 7 critical production support on Oracle & SQL Server to all Production, development and clustered servers.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Applied PSU's in Development, Testing & Production Environment.
• Configured databases replication using Golden Gate.
• Implementing Oracle database backup & recovery solutions using RMAN and manual methods.
• 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.
• Fine tuning of database objects and server to ensure efficient data retrieval.
• 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.
• 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 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 usingexecution plansfor 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 SERVER 2016/2014/2012, Windows Server 2012/2008 R2, SSIS, SSRS, SQL Profiler, SQL Tuning Advisor.

Confidential

Database Lead

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 cummulative & 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.
• MigratedNon ASMdatabases toASM.
• 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

Confidential

Sr. DBA & BI Analyst

Responsibilities:

• Installation, Administration and Maintenance of SQL Server Instances.
• Setup Test, Dev, Staging and Production Environments.
• RunningIndex tuning wizard and rebuilding indexes(Clustered/Non-Clustered) for faster query response.
• ImplementedSQL Replication for Load Balancing.
• Actively Involved inSQL Replicationinsharing the access load betweenseveraldatabases servers having identical databases.
• Worked withTransactional Replicationwhere data changes frequently and need for constant refreshing of the data.
• Involved and responsible fordevelopment of Reports using SSRSand populating theWarehouse 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.
• Usedindexestoenhance the performanceof individual queries and enhance the Stored Procedures.
• Managed all indexing, debugging, optimization and performance tuning usingSQL ProfileandSQL Server Tuning advisor.
• Designed, developed, and tested stored procedures, views andcomplex queriesforReports 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, Windows 2008.

Confidential

Applications & Databases Manager

Responsibilities:

• Installed and administered SQL DB 2014/2 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/2, Windows Server 2008/2003.

Confidential

Database Consultant

Responsibilities:

• Installation of Oracle Software and Database creation.
• Created 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)
• 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.

Confidential

 Application & Database Administrator

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.
• 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 standby database.
• 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.
• 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.