PROFESSIONAL SUMMARY

• 9 plus years of experience in IT industry having strong skills in Oracle & SQL Server database Administration.
• Nearly 2 years of experience on AWS cloud computing which enables organization to obtain flexible, reliable and cost - effective IT-infrastructure.
• Experience in setting up, trouble shooting and maintenance of production server databases.
• 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.
• Proficiency in designing and implementing the OracleReal Application Clusters (RAC)on for anOLTP applicationwith TransparentApplication Failover.
• Good knowledge in configuring Network for RAC (Public IP’s, Private IP’s, Virtual IP’s & SCAN).
• Expertise in supporting multi node RAC cluster.
• Expert in ASM Storage Management.
• Virtuous knowledge in Oracle Golden Gate Installation, configuration & troubleshooting Golden Gateissues.
• Strong experience in unidirectional replication management.
• Good hands on in data encryption using blowfish algorithm.
• 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 upgrades and Patch upgrades.
• 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.
• 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.
• Expert in Monitoring and troubleshooting Log Shipping.
• Experience in Replication - Snapshot, Merge and Transactional.
• Good Knowledge in Always on Availability group for HADR.
• 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.
• Familiar with the TDE & Always encrypted features.
• 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.
• 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.
• Can work in a fast-paced environment, good team player and can work independently. Helped the database developers on technical issues.
• 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 ofAWSresources, 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 & dynamic web application 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.

TECHNICAL SKILLS

Languages: SQL, PL/SQL

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

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

Tools & Utilities: SSMS, SSMA, SQL Profiler, SSTA, SSIS, SSRS, DBCA, NETCA, Export/Import, Data Pump, RMAN, ORACLE Toad, SQL developer

PROFESSIONAL EXPERIENCE:

Confidential

Sr. DBA & ETL developer

Responsibilities:

• Migration of homogeneous & heterogeneous databases carried out from on premises to AWS RDS & AWS EC2 to AWS RDS.
• Capable hands in using Schema conversion tool & AWS DMS.
• Good knowledge in implementing Amazon RDS’s (Oracle & SQL Server).
• Handling RDS automated backups and DB snapshots.
• Configuring DB Read replicas on databases for high performance.
• Multi AZ deployment of RDS Databases for High Availability.
• Launch ofAWSresources, such as Amazon EC2 instances, into customized VPC.
• Customizing the security groups and arresting the data leakage.
• AWS - VPC, Public & Private Subnets, Route Tables, Internet & NAT Gateways.
• Assign static private IPv4 addresses to the instances that persist across starts and stops.
• Define network interfaces, and attach one or more network interfaces to the instances.
• Change security group membership for the instances while they're running.
• Add an additional layer of access control to subnets in the form of network ACL’s.
• Users, Groups & Roles creation using Identity and Access Management.
• Expertise in launching Amazon EC2 in public and private subnets.
• Creating customized AMI’s and generate automated scripts using user data.
• 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 and 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 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: AWS, Oracle 11g R2/10g, Linux, SQL Server 2016/2014/2012, Windows Server 2012/2008 R2, SSIS, SSRS, SQL Profiler, SSTA, Perfmon.

Confidential

Database Administrator

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.
• Worked onSQL 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.
• Heavily involved and responsible fordevelopment of Reports using SSRSand populating theWarehouse data using SSIS.
• Worked and responsible for design, implementation and enhancement of ETL jobs
• Create Users and assign permissions based on the level of database access the user would need.
• Create Linked Servers to SQL Servers and other databases such as Oracle.
• Design 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.
• Designed, developed, and tested stored procedures, views andcomplex queriesforReports distribution.
• Documenting major changes to the SQL Servers.
• Ensuring that storage and archiving procedures are functioning correctly.
• Developing, managing and testing back-up and recovery plans.
• 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.
• Created packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server.
• Configured 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.

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

Confidential

Database Administrator

Responsibilities:

• Launch ofAWS services such as Amazon EC2 instances into VPC.
• Creating AWS - VPC, Public & Private Subnets, Route Tables, Internet & NAT Gateways.
• Assign static private IPv4 addresses to the instances that persist across starts and stops.
• Define network interfaces, and attach one or more network interfaces to the instances.
• Change security group membership for the instances while they're running
• Add an additional layer of access control to instances & subnets using ACL’s & Security groups.
• Identifying the Availability zones within Regions to deploy EC2 instances.
• Users, Groups & Roles creation using Identity and Access Management.
• Alerts configuration using Cloud watch. Knowledge on SQS, SNS & SWF.
• Expertise in launching Amazon EC2 in Public, Private & Hybrid cloud.
• Creating customized AMI’s and generate automated scripts using user data.
• Implementing ELB on private EC2 instances along with Auto scaling.
• Implementation of CDN using cloud front for a better performance and keep lower latency.
• Installing & configuring Oracle cluster ware & Database Software.
• Setup and configured 2 node Oracle 11g R2 RAC with ASM.
• Managing ASM disks, Fail groups, Disk groups.
• Troubleshooting using cluvfy & handling common issues that arise during integration.
• Installed Golden Gate software in Test and dev instances.
• Configured Golden gate on production server.
• Setup classic capture replication mechanism using golden gate.
• Configured Golden Gate to achieve unidirectional replication.
• 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 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 withReal Application Testing(RAT).
• 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)
• Resolved/Diagnose Node Eviction.

Environment: AWS EC2, S3, Oracle 11g R2, RHEL 5.4

Confidential

Database Administrator

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.
• Created 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.

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.
• Upgraded databases by applying 10.2.0.5 patch set on 10.2.0.3.
• 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.
• 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