SUMMARY:

• 10 years of Database Administration and Development experience on MS SQL Server 2017 through 7.0 in 24 * 7 environment and Large Data bases in size.
• Implemented Transactional Replication as a part of high availability solution.
• Hands on experience and outstanding knowledge of high availability SQL Server solutions, including replication and SQL Server clustering, log shipping and Mirroring, and Always on with multiple nodes.
• Architect cloud solutions from proof of concept to delivery in various platforms, Azure PaaS, Oracle HR and HCM, AWS, and other cloud providers and vendors.
• Proficient with SQL Enterprise Manager, Query Analyzer, Management Studio, Business Intelligence development studio, rescheduling jobs with SQL Server Agent, SQL Profiler, restoring database using full, differential, and log backups. OLTP, data warehouse design, trouble shooting.
• Experience in MS SQL Server database development and administration in enterprise production environment including server installation, configuration, upgrade, maintenance, performance tuning, query optimization, backup/restore, recovery, migration, monitoring, security planning and trouble - shooting.
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tunes the same to improve performance.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support. Extensive usage of Proactive Monitoring tools of SQL Server.
• Extensive experience with Storage Capacity Planning, including system storage allocation, on-going capacity analysis and planning future storage requirements
• Worked closely with developers and testers, my objective was to deliver projects within scope, time and costs while following department standards, methodologies and guidelines.
• Worked in production environment providing Production Support, Production database server implementation, Database Migration.
• Expert in Data transfer and Transformation using tools like DTS, BCP, Bulk Insert & SSIS.
• Extensive Experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client-server-based applications)
• In-depth knowledge of T-SQL and having experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Experience in implementing & monitoring of Replication Models Snapshot, Merge and Transactional
• Experience of server-client computing and good understanding of relational database environments
• Provide capacity planning analysis for database resource requirements. Assigning of database change control tasks (CCT/tickets) using CA tool. Support and trouble-shoot jobs and other system control processes.
• Experience in planning and implementing MS SQL Server Security and database permissions.
• Experience in creating Jobs, Alerts, Database / SQL Mail Agent.
• An excellent team member with an ability to perform individually, good interpersonal relations, effective communication skills, hardworking and prominent level of motivation. A quick learner with an aptitude for taking responsibilities

TECHNICAL SKILLS:

RDBMS/ DBMS: MS-SQL Server 6.5 to 2017 and Azure, AWS, MYSQL, Oracle, Informix, DB2, Teradata, Cloudera-HADOOP

Language/Tools: T-SQL, REDGATE, LITESPEED, ORACLE, VEEAM, SOLARWINDS, TSM / Symantec backup

Programming Languages: C, C++, T-SQL

Operating Systems: Win 2k8/2k3/Win 7/XP, Win NT 4.0, Win server 2003/2008/ 2008 R2

PROFESSIONAL EXPERIENCE:

Confidential, Las Vegas, NV

Responsibilities:

• Rotational weekly on call support for production databases, Troubleshooting and Problem solving.
• Migrated multiple existing databases from 2005 to SQL server 2008 R2, and 2016
• Solely responsible for the upgrading all SQL server SP/CU, engaging multiple teams/vendor and collaborating downtime as well remediate ongoing issue relating to it.
• Migrated HR and HCM system to Oracle Cloud, including various technologies involved like WebSphere connections, and DataStore
• Migrated Multi-layered, multiple Vendor POS system to single source MS Dynamic 365 and Azure.
• Migrated in house Vendor supplied systems to Azure and AWS.
• Implemented in house hot application databases to Always on availability group.
• Completed vulnerability scan and remediation throughout 600+ ms enterprise database system.
• Involved in variety of projects with different technologies and database requirements.
• Responsible for the installation, configuration of MS database services & integration services
• Providing day-to-day administration tasks like log management, error logs, current activities and scheduled tasks.
• Adding and Removing tables to setup Replication and Monitoring for support.
• SQL Server Installation includes (setting up Maintenance job, TSM backup, Altiris packages distribution, reboot schedule)
• Active in SP upgrade and TLS1.2 compliance, issues such as missing cache .msp files and repairs.
• Active in migration project involving multi TB databases to AWS, as well application and vendor products.
• Exposure to variety of applications and RDBMS and NoSQL like Hadoop -Cassandra, Teradata, Informix, DB2
• Maintenance of backup and recovery plans for system and user databases.
• Developed Stored Procedure to audit the security privileges on the server and send the reports to the auditor via database Mail and implemented this on Servers.
• SQL code review & Performance Testing using sample test cases.

Environment: Windows Server, SQL Server 6.5-2017 and Windows clustered environment, Always On Availability Groups. AIX7.2, DB2, Teradata, Informix, AWS, Azure, and Private Vendor Clouds.

Confidential, Marshfield, WI

SQL Server DBA

Responsibilities:

• Highly worked on Administration, Database Design, and Performance Analysis on very large and highly transactional production databases.
• Installed and configured SQL Server 2005/2008 (R2) on new servers with service packs.
• Support and troubleshoot very large databases (VLDB).
• Extensively work on Snapshot and Transactional Replication.
• Work on 32 bit, x64 bit and i64 clustered and standalone server environments.
• Configured data files; log files and tempdb as per RAID features.
• Reconfigure the default locations of the data files, log files and error log files onto the SAN environment for all the servers.
• Work with tools like SQL Server Dashboard, SQL Profiler and Activity Monitor for event monitoring and performance monitoring, and make recommendations based on the results.
• Provide flexibility and performance to simplify the creation and maintenance of partitioned tables in SQL Server 2005.
• Extensively work on database partitioning for better performance in SQL Server 2005.
• Fix data issues and write various SQL scripts and procedures for migration process.
• Involved in Data Compression, Hot add CPU, Fact Table size reduction and improved performance using SQL Server 2008.
• Expert in using and implementing DMV’s, DMF’s, data partitioning, DDL triggers, Mirroring and Online indexing.
• Develop all the required stored procedures, user defined functions, and triggers using T-SQL and PL/SQL.
• Implement data availability solutions like Replication, Log shipping Database Snapshot, and Fast Recovery.
• Optimize the performance of queries with modifications in T-SQL queries, remove unnecessary columns, eliminate redundant and inconsistent data, and normalize tables.
• Create and modify Stored Procedures and Functions to generate reports.
• Monitor and modify performance using execution plans and Index tuning.
• Migrated SQL Server, SQL Server R2
• Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server. Installed couple of SQL Server 2005/2008 on cluster environment.
• Implement and manage the clustering environment like Active/Passive and Active / Active.
• Use log shipping for synchronization of database.
• Responsible for day-to-day activities, such as backups to the disk and restore the databases and transaction log on production/development servers as per business / IT needs using SQL Safe.
• Troubleshoot and fine-tune databases for performance and concurrency.
• Provide 24x7 Production Database on-call support.

Environment: MS SQL Server 2005/2008R2, Windows 2003/2008, MS Access, Erwin.

Confidential, Round rock, Texas

SQL Server DBA/Developer

Responsibilities:

• Monitoring SQL jobs, Performance bottlenecks, configuring databases, backup/restore DBs.
• Implemented different types of Replication Models like Snapshot, Merge and Transactional using SQL SERVER 2008.
• Using performance tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Added error handling techniques like TRY-CATCH in the procs.
• Raidster internal tool used to track the bugs and to get the consolidated bug reports.
• Involved in the Design of Database and creation of tables, stored procedures, User Defined Functions, DTS packages using SQL Server 2005, 2008.
• Experience in planning and implementing MS SQL Server Security and database permissions.
• Daily Tickets and other Deployment/New Application Rollout’s and Change Requests.
• Implemented SQL security for application users using Active Directory. replicated databases onto other server including QA, Testing.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2008.
• Monitoring the CPU usage, IO statistics, Memory Usage to identify any OS level performance killers, enabling database level trace for performance test.
• Migrating entire database environment from SQL 2005 to SQL 2008.
• Query tuning and performance optimization for the database and highly transactional 100% Uptime applications.
• Database space management/OS level space management, db sizes varied from 5GB to 1.2TB
• Query tuning and performance optimization for the database.
• Setting up Alerts using SQL Mail.
• Involved in all new projects/application development based on SQL Server, Client/Server Environment.

Environment: SQL Server 2005/2008, Windows 2003/2008, T-SQL, Profiler, MYSQL. Crystal Reports

Confidential, Nashville, TN

SQL SERVER DBA

Responsibilities:

• Actively involved as part of a team in gathering and analyzing the needs of End User Requirements and Online System Application.
• Modified existing database by adding tables, adding columns to existing tables and relationships to support online system.
• Created Check Constraints to apply business rules for data consistency and Integrity
• Created Views, Indexed Views, and Partitioned Views as required by front end developer for easier implementation on web pages, and wrote instead of triggers on those views to provide efficient data manipulation.
• Worked on DTS and BCP to transfer data from legacy Server to SQL Server, to load Flat files to SQL Server, database backup and restoration of backup.
• Involved in Troubleshooting existing and new DTS packages.
• Configured SQL mail agent for sending automatic emails when a DTS process is failed or succeed.
• Optimized the performance of Queries and Store Procedures with modification in T-SQL statements, by removing unnecessary columns, by eliminating redundant and inconsistent data, by renormalizing tables, and created indexes wherever necessary.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Planned the Complete Backing up of Database and Restored the Database from Disaster Recovery.

Environment: SQL Server 2008/2005, Windows 2003 Server, T-SQL, IIS

Confidential, Kalamazoo, MI

SQL Server DBA/Developer

Responsibilities:

• Involved in Providing Complete Database and Application Support which includes Server Upgrades, Build out’s and Migration of Servers from SP3
• Performance tuning operations like Load balancing, Archiving, Indexing, Query optimization, performance monitoring.
• Controlling day-to-day activities of Production database and troubleshooting the issues.
• Index Defragmentation by Rebuild/Reorganize of Indexes on a monthly basis across all Databases.
• Involved in various Transformation and data cleansing activities using various Control flow and data flow tasks in SSIS packages during data migration
• Providing technical helpdesk support & assistance for online Production issues 24X7
• Co-coordinating with Team Members & supporting the clients for product implementation & daily support activities
• Hands on experience in designing Enterprise and Ad hoc reports using MS SQL Server Reporting Services (SSRS).
• Installation, configuration and supporting of IIS servers.
• Responsible for Installation, Upgrade, Design, and Implementation of SQL Server 2000 and 2005 Enterprise database environment for multiple client’s sites.
• Responsible for more than 50 SQL Server instances and 100 databases
• Resolved database performance issues (I/ Confidential saturation, disk bottleneck, network bottleneck, etc.,), database capacity issues, replication, and performance tuned the stored procedures for optimal efficiency using execution plans, profiler traces and database engine tuning advisor
• Created and implemented best backup, recovery strategies (Full Backup Model with 1-hour period transaction logs backup.) and re-indexing process.
• Designed and implemented Disaster Recovery sites using Mirroring and Log Shipping

Environment: SQL Server 2000/2005, Windows 2003/2000, T-SQL, Profiler, Lite speed. IIS.

Confidential

Database Engineer / System Engineer

Responsibilities:

• Administered and maintained production/Development servers with more than 1 TB of database size with complex structures. Performance metrics reports daily, weekly and monthly.
• Preparing database schema, data insertions and retrievals, procedures, triggers, scripts and queries with abilities to prioritize and operate proactively.
• Expertise in setting up and troubleshooting Database mirroring, Optimized working process.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
• Creation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of user.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
• 24/7 on call support, created various jobs to check health of the server and to troubleshoot.
• Tuned servers to the peak for maximum performance by configuring memory and various server level parameters.

Environment: SQL Server 2000/7.0, Windows 2003/2000, VB.Net, T-SQL, IIS