OBJECTIVE

• An IT Engineer and leader with over a decade of experience in multiple platforms looking to expand in a current role with more leadership opportunity. Aiming to use my superb analytical skills and technical knowledge not just in On - PREM database but in AWS Cloud platform full time. Certified in AWS Solution Architect Associate but working to get certified in Solution Architect Professional with one motto: “Never stop Learning”.

SUMMARY

• Over 10 years of IT experience in Database, Windows, Networking and Storage. Administering Database, System Analysis, Design, Development & Supporting Standalone and Cluster SQL Servers 2005/2008/2008 R 2/2012/2014/2016/2017 , Informix DB Server, Oracle and Oracle RAC, RedShift, MySQL/Aurora and multiple other AWS Services in all Production/ Development/ Testing environment.
• Primarily focused in MS SQL Server Installation, Performance Tuning, client/server Connectivity, Building Servers, Trouble shooting, Clustering, Query optimization, back-up/recovery and troubleshooting on VLDB databases.
• Routine and Emergency upgrade/patch of SQL Servers. Migrate SQL server databases from older versions to newer versions, Oracle to Aurora in AWS.
• Assisted in migration of Windows SQL Servers to EC2 instances in AWS.
• Experienced on using various tools within SQL Server including SQL Server Management Studio (SSMS), SQL Server Profiler, SQL Server Agent, Extended Events, Database Engine Tuning Advisor, BCP and Bulk Load.
• Expertise in Business Intelligence tools using SQL Reporting Services (SSRS), SQL Integration Services (SSIS) and SQL Analysis Services (SSAS).
• Managed day-to-day user activities and support on-call on various platforms like SQL Server, Oracle, Informix, MySQL, Aurora, Postgres & Redshift.
• Create source DBs for DELPHIX and set up masking. Create vDBs (Virtual databases) in lower environments with real time prod data that is masked. In compliance with PCI & PII Audit.
• Experience working in a clustered OLTP/OLAP environment with Very Large Databases (VLDB) as well as Always-ON AG for SQL Servers.
• Develop maintenance plans and write scripts to collect database statistics, index usage, automated DBCC checks and monitor/estimate growth of the databases.
• Migration of databases using Backup/Restore (Netbackup/Rubrik), setting up Log-shipping for minimal downtime.
• Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional.
• Implement/setup high availability such as Clustering, Database Mirroring, Log Shipping, and Replication.
• Set up service broker for messaging as well as CDC (change data capture) for analytics applications.
• Create users/roles in AWS and write policies for S3 buckets as well as IAM roles.
• Maintain software development life cycle (SDLC) and project methodologies.
• Use transformation tools like DTS Packages, SSIS, BCP and BULK INSERT for various applications.
• Used the SSIS Import/Export, migrated the Heterogeneous Database like Oracle and Access database, flat files to SQL server.
• Working/supporting on-call on 24/7 Production as well as Development Environments in multiple platforms.
• Leadership and excellent communication skills.
• Recipients of multiple STAR Awards at Choice Hotels which is handed in recognition of outstanding contributions to the company.

TECHNICAL SKILLS

Operating Systems: Implementation & Administration of Windows NT/ Windows 2000 Advanced Server / Enterprise Server 2003/2008/2008 R2 / Windows XP/Standard, Windows 98, Linux.

SQL Server Tools: SQL Enterprise Manager, Profiler, Query Analyzer, Export & Import (DTS), SQL Server Management Studio (SSMS), SSIS, SSRS,SSAS, SQL Server Business Intelligence Tools.

Database Applications: Oracle, PostgreSQL, MySQL, AWS, Informix, SQL Server, Redshift

Programming Languages: C, C++, T-SQL, Java, .NET

Clustering Technologies: Microsoft Cluster Server (MSCS), SQL Server cluster service, AlwaysON

ETL Tools: DTS, SSIS

Reporting Tools: SSRS

PROFESSIONAL EXPERIENCE

Confidential

Database Engineer/AWS Support

Responsibilities:

• Daily support/maintain of databases in multiple environments including MS SQL, MySQL/Aurora, Oracle, Informix and AWS Services like S3, Redshift.
• Heavily involved in database migration from On-premise data center to the cloud.
• Migrated Windows SQL server to EC2 Instances with the help of Windows Team from On-premise to AWS using tools like Cloudera.
• Analyze/Report on migrated databases for future releases in AWS and present best-case scenario for RDS or EC2 server.
• Using backup tools like Netbackup/Rubrik to schedule backups, mount Virtual DBs for temporary restores and migrations on-prem or in cloud.
• Create and manage virtual databases using third party software Delphix. Also leveraged Delphix masking engine to restore real time production database to lower environments with masked data to protect PCI and PII data.
• Build and support CDC (Change Data Capture) functionality in SQL Server for data analytics team.
• Work with developers in various tasks including query enhancements, automating jobs and running queries for developers where they do not have access.
• Deploy reports in SSRS for various reporting project and maintain security and version of these reports.
• Deploy DTSX packages for various systems, maintain packages and troubleshoot packages when there’s issue.
• Patch SQL Servers with latest service packs and cumulative updates to keep servers in most updated version as possible for business needs or regular maintenance.
• Database creation, writing database performance tuning scripts, backup planning and implementation with Database restore activity.
• Write Stored Procedures based on business needs and review stored procedures written by the development team to make sure it’s optimized.
• Creation and management of database maintenance plan for various database consistency checks. E valuate database performance and performed tuning, backup, restoration and disaster recovery scenarios .
• Installation of MDW database. Configure management data warehouse. Create/Upgrade management data warehouse database. Configure data collection in MDW and create jobs.
• Troubleshoot issues with data partitions and service broker performance issues.
• Support Informix and MySQL environments to run queries and maintain database activity
• Responsible for Database backup and recovery such as build the master database; if crash, recover the master and user database in point in time .
• Responsible for change managements, created the documentation for SQL server and service packs installations.
• Configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed.

Confidential

Sr. SQL DBA

Responsibilities:

• Login and User Management: Create Logins and assign roles based on the user.
• Scheduling Jobs and Alerting using SQL Server Agent.
• Database creation, writing database performance tuning scripts, backup planning and implementation with Database restore activity.
• Write Stored Procedures based on business needs.
• Review Stored Procedure written by the development team to make sure the Stored Procedure is optimized and will not be resource intensive.
• Migration of databases/users between different instances and servers.
• Install/Upgrade the application and apply patches based on business needs.
• Creation and management of database maintenance plan for various database consistency checks.
• Evaluated database performance and performed tuning, backup, restoration and disaster recovery.
• Installation of MDW database. Configure management data warehouse. Create/Upgrade management data warehouse database.
• Configure data collection in MDW and create jobs.
• Maintain the existing replication environment.
• Run queries in the PostgreSQL environment.
• Responsible for Database backup and recovery such as build the master database; if crash, recover the master and user database in point in time .
• Responsible for change managements, created the documentation for SQL server and service packs installations.
• Configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed.
• Create and manage DTS/SSIS packages to migrate or get the data for various business needs.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Use BCP import/export or SSIS export/import to transfer data.
• Work with windows team to failover the cluster if needed after windows patching.
• Plan and execute deployments in multiple environments (QA/DEV/TEST/ProdQA/PROD), confirm and test the back out plan for each deployment and validate.
• Use SQL Agent/Job to create multiple alerts to prevent outage (disk space/log space/ concurrency alert)
• Perform day to day activities/ monitor database and advice the team to improvise the database or application in any way.

Environment: MS SQL Server 2005 /2008/2008 R2/2012/2014, Analysis Services, SSIS, Reporting Services, XML.

Confidential

Database Engineer

Responsibilities:

• Migration of database from local instance to the cloud.
• Create logins, assign correct permission and privileges to the users as well as individuals working with the application team.
• Database move using database import/export.
• Restore Oracle database using crash dump file.
• Migrate Crystal reports to SSRS 2012 using third party tool.
• Set up Mirroring, resolve any issues that comes with Mirroring and also provide support to other customers on mirroring issues if needed,
• Create triggers and views, update tables in production as necessary for the application to work without any issues.
• Create users, schemas and tables in the new Oracle12c environment.
• Migrate data from the tables to the newly created schemas in the cloud.
• Create jobs and maintenance plan in SQL to run jobs for backup and re-index.
• Provide 24/7 support to the team and also responsible for all the calls that require database maintenance like slowness or outage.
• Running DBCC consistency checks, and fixing data corruption in user databases.
• Responsible for Database backup and recovery such as build the master database; if crash, recover the master and user database in point in time.
• Design, develop and schedule the various DTS package for data migration, bulk load data using BCP, import/export.
• Used DMVs (Dynamic Management Views) to specialized views and functions that return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance.
• Identify and analyze expensive T-SQL stored procedure by using the SQL Profiler, SQL analyzer, Also, use tuning advisor for additional info.
• A great team player with an excellent communication skill.

Environment: SQL Server 2012/2008R2/ 2008/2005, Windows Server 2003/2008 R2, DTS, SSIS, SQL Profiler, Oracle 12c

Confidential

SQL DBA

Responsibilities:

• Installation of SQL Server in a clustered environment and standalone servers.
• Installation of service packs and Cumulative Updates for SQL 2005 and 2008/2008R2 standalone and clusters.
• Performed Migration of database and DTS packages from SQL Server 7.0/2000 to 2005/2008/2008 R2 servers (both cluster and standalone servers).
• Create the necessary indexes to improve the query performance.
• Design, develop and schedule the various DTS package for data migration, bulk load data using BCP, import/export.
• Used DMVs (Dynamic Management Views) to specialized views and functions that return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance.
• Identify and analyze expensive T-SQL stored procedure by using the SQL Profiler, SQL analyzer, Index tuning wizard and running self created SQL scripts.
• Performed Database refreshment from development to production environment and maintain the database creating necessary jobs.
• Installation of MDW database. Configure management data warehouse. Create/Upgrade management data warehouse database.
• Performed Capacity planning, requirement forecasting, Scaling up the Hardware to optimize the applications performance.
• Experience creating Linked Servers between SQL server 2005/2008 and Oracle Server.
• Update the servers/database on the OVO monitoring for the constant monitoring of databases and server for any incoming issues.
• Provided 24/7 Supports for Production & Development of MS SQL Servers.
• Stay in the meetings with project managers and customers to discuss any ongoing issues and any future change.
• Monitor different issues from the database standpoint to the server standpoint and solve the issue before it impacts the users.
• Handle multiple tasks and responsibilities independently as well as a proactive team member.
• Responsible for Database backup and recovery such as build the master database; if crash, recover the master and user database in point in time.
• Perform regular reviews of database security and adjust accordingly to ensure access and modification only by authorized users and/or applications.
• Involved in the migration of existing DB environment to a highly available Active Passive Cluster DB environment.
• Running DBCC consistency checks, and fixing data corruption in user databases.
• Configure the backups and restore using the third party software tool (Lite Speed)
• Developing Database Backup Scripts and automating this process.
• Functioning both as an Application and Infrastructure DBA and performing the activities that accompany each of the responsibilities.
• Assign teammates appropriate assignment and monitor the workload of other DBAs to complete it before the end of timeline.
• Administration of the SQL Server by creating USERS and synching the USERS with appropriate roles & grant privileges to users and roles after the database migration .
• Configured Active/Active and Active/passive SQL Server Clusters.
• Monitoring the event logs and server logs for troubleshooting.
• Interact with customers and discuss the downtime required to perform a new project and explain the risk and implementation plan.

Environment: SQL Server 2012/2008R 2/ 2008/2005/2000 , Windows Server 2003, DTS, SSIS, SQL Profiler, SSRS