SUMMARY

• Microsoft Certified Solution Associates with around 10 years of experience in database administration and development that includes RDBMS and NoSQL end to end administrative support and designing and developing Microsoft Business Intelligence Solutions.
• Expertise in designing SQL server backup strategy with defined service level agreement (SLA), Recovery Time Objective (RTO) and Recovery Point Objective (RPO).
• Expertise in Database High Availability and Disaster Recovery solutions using Mirroring, Log Shipping, Replications.
• Skilled at managing activities involving installation and configuration of SQL server Clustering (Active - Active/Active-Passive), Always-On Availability. Configured up to 6 nodes cluster server.
• Extensively worked on migrating On-Premises server to Microsoft Azure cloud.
• Experience in upgrading MS SQL Server 2000 to 2005, 2005 to 2008 to 2012, 2014 & 2016 and applying require Hot-Fixes.
• Proven track record in supporting Very Large Database (VLDB) and troubleshooting performance problems, fine-tuning of databases and Index analysis
• Expertise in designing, developing and managing Microsoft Business Intelligence Solutions (MSBI) i.e. SSIS, SSAS and SSRS.
• Migrated SSIS packages from Visual studio 2008 to Visual studio 2012 as a part of data warehouse upgrades.
• Extensive experience in solving performance issues to alleviate the CPU, Memory and Disk IO Pressure and resolving slow running query issues using SQL in-built (SQL profiler, Tuning Advisor and Perfmon) and third-party tools like IDERA, SQL-SENTRY, RED-GATE, QUEST software.
• Implemented and maintained peer to peer Database Replication and Developed the stand-alone Database for Reporting Servers.
• Hands-On experience in Microsoft Azure Data Access strategy for File service, BLOB and Tables.
• Skilled at designing Azure Data Security options that includes implementing Azure SQL Firewall, Azure SQL Security and Azure Blob Encryption.
• Strong in Database Objects development - Tables, Views, Triggers, Stored procedures, Functions, Cursors, Synonyms, Linked-Server and T-SQL batches.
• Involved in design and migration of SSIS and SSRS servers from one storage block to other storage block and change in VLAN for servers and adding servers in the Load Balancer
• Extensively worked in OLTP & OLAP environment that includes Production (24x7), QA and development databases in SQL Server.
• Experience in migration of Data from Excel, Flat file, Oracle9i/10i to MS SQL Server by using SSIS, BCP and DTS utility.
• Working Experience in documenting complex database applications, and data;
• Implemented SQL queries using DML and DDL statements to extract large quantities of data from multiple data points on MS SQL and Teradata SQL Assistant.
• Good experience in writing MDX queries, creating cubes, and data source views, named queries, dimensions and deploying of analysis services projects using SQL Server Analysis Services (SSAS) 2005/2008/2012/2014.
• Experience in working with Windows servers 2003/2008/R2/2012 Enterprise and Advanced Server.
• Implemented CDC (Change Data Capture) and Change Tracking in SQL Server 2008/2012/2014 for capturing changes for a data warehouse environment.
• Experience in overcoming the roadblocks and provide solutions and implement migrations for hardcoded old applications with SQL Server Instance name and IP addresses
• Experience with Table Partitioning and implemented Sliding window partitioning for Application Tables.
• Exposure to multiple database platforms like Oracle, MySQL and Mongo DB.
• Experience in understanding and choosing single and elastic databases as per billing and performance parameters
• Experience in Azure (Iaas, Pass, Sass).
• Worked in Analyzing the Project Scope at an Architect level with Business and Implemented the Project in time in Budget and Involved in Complete SDLC.
• Involved in effort estimation for the requirements for the project.
• Worked effectively with Business Analysts and Project managers for assigned tasks and deliverable timelines.

TECHNICAL SKILLS

• MS SQL Server 2016/2014/2012/2008 R 2/2005/2000/7.0 , Oracle 11i/10g
• MySQL 4.1, PostgreSQL and MS Access 2016/2010/2007/2003
• T-SQL, C/C++, Visual Studio 2015/2005/2003 , XML, HTML, ASP.NET, VB.Net.
• TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP, Cisco Routers And switches
• MS Azure Cloud Service (Iaas, Pass, Sass), AWS (EC2, S3, RDS)
• IIS and IBM WebSphere.
• Microsoft Analysis Services(SSAS), Red Gate tools
• Windows Server 2016, 2012, 2008R2 EE, Windows Server 2008 (SE, EE), Windows Server 2003 EE, Windows 2000 Server/Advanced Server and Windows, UNIX, Solaris.
• SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Data transformation services (DTS), IBM Data Stage, SQL Server Data Tool (SSDT), Crystal Reports.
• Always-ON, Failover Clustering, Network Load Balancing, Log Shipping, Mirroring, Replication
• MS Visio and Power Designer
• SCOM, BMC Patrol, Idera, SQL Server Profiler and Performance Monitoring.
• Business Objects/Crystal Reports, Tableau, SSRS (Report Builder)
• Word, Excel, Access, Outlook, Outlook Express and Powerpoint.
• DTS, SSIS, BCP, SQL Loader, Import/Export Wizard.
• Red-Gate, TOAD, WMI, COM, Microsoft Silver Light, Share Point Server, Perfmon, Resource Monitor, Commvault, Benchmark factory, SQL Optimizer for Oracle.

PROFESSIONAL EXPERIENCE

Confidential, Tampa, Florida

SQL Server D BA

Responsibilities:

• Responsible for administrating and managing more than 150+ SQL servers including MSSQL, MongoDB, PostgreSQL, and Oracle.
• Migrated all production On-premises servers to Microsoft Azure Cloud.
• Migrated On-premises servers to Amazon Web services.
• Installed, configured and managed 2008/2008R2/2012/2014 and 2016 database server with all best practices recommended for application.
• Upgraded SQL server service packs and applied required hot-fixes to resolved SQL bug.
• Designed, developed and implemented a Disaster Recovery and Security Management system for the point in time recovery.
• Implemented Transparent data encryption, decryption, EFS and Auditing on all production servers for security compliance.
• Configured Snapshot and Transaction Replication for reporting users to use subscriber node as reporting server on non-prod servers.
• Installed and configured SQL Cluster and Always-On availability group on all production environment and routed reporting users to connect secondary node with read-only access.
• Decommissioned standalone server and kept all configuration backup on Azure BLOB for security purpose.
• Migrated data warehouse server from standalone to the cloud (Azure and AWS) as per the requirement.
• Designed and fine-tuned ETL solutions and TSQL’s and gained maximum performance.
• Implemented Power-shell script to monitor SQL and event viewer logs and generate Incident if needed.
• Configured Nagios alerts for database server alerts.
• Developed essential database alerts (Blocking, deadlock etc) to monitor database health regularly
• Created and scheduled database health report to monitor DMV statistics regularly, this helps us to find the root cause of performance issues and area of improvement
• Used DMVs, DMFs, Perfmon for identifying bottlenecks and resolving.
• Implemented standard checklist and review the code prior to deployment to avoid performance issue.
• Implemented CDC (Change Data Capture) and Change Tracking in SQL Server 2008/2012/2014 for capturing changes for a data warehouse environment.
• Designed, consolidated SSIS and SSRS server using Autosys and Load balancer technologies
• Implemented IN-MEMORY feature on report database to get maximum output.
• Analyzed and redesigned optimization query to improve performance as per application specific requirement
• Experts in Design, Architecture and providing solutions
• Involved in effort estimation for the requirements for the project.
• Designed and Fine-tuned SSIS packages that improved more than 60% of query performance.
• Initially loaded data into staging tables from Facets using different transformations, control flow tasks, loop containers, and data flow tasks, then moved the data into different Schema's.
• Investigated Data Discrepancies between Various Source Systems and the Data Warehouse that affect the flow of data through EDI for Government Compliance.
• Analyzed and fixed application workflow error and designed store procedure to cleaned workflow defects.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs.
• Integrated TFS with SQL data tools to manage MSBI stack packages properly in DEV, QA and PROD environments using check-in and check out and have maintained history for every minor change.
• Co-ordinate with all the business users and process owners to complete SDLC processes.
• Worked effectively with Business Analysts and Project managers for assigned tasks and deliverable timelines.
• Installed and configured MongoDB, PostgreSQL, and MySQL.
• Implemented and deployed replication in MongoDB.
• Configured multi-master replication on PostgreSQL.
• Created schema on Oracle RDS with appropriate permission.
• Migrated database to the different instance for development purpose.
• 24/7 Production On-Call Support.

Environment: SQL Server 2016/2014/2012/2008 /R2/2005/2000, Mirroring, Transactional-Replication, Windows Servers, Linux, Amazon Web services, Graphite, Service-now, JIRA, T-SQL, SSIS, SSRS, SSAS, SSDT, Oracle 11i/10g/9i, TFS, Confluence, lite Speed, XML windows Services, MS-Excel, MS Azure, MDW, SQL Server Replication, Business Objects,, Cluster Environments, Red Gate, CDC, TDE, Nagios, Active directory, Power-shell, IIS, IDERA, MySQL, MongoDB, PostgreSQL, Casandra.

Confidential

SR. SQL Server D BA/Developer

Responsibilities:

• Responsible for administrating and managing more than 150+ SQL servers including MSSQL, MongoDB, PostgreSQL, and Oracle.
• Migrated all production On-premises servers to Microsoft Azure Cloud.
• Migrated On-premises servers to Amazon Web services.
• Installed, configured and managed 2008/2008R2/2012/2014 and 2016 database server with all best practices recommended for application.
• Upgraded SQL server service packs and applied required hot-fixes to resolved SQL bug.
• Designed, developed and implemented a Disaster Recovery and Security Management system for the point in time recovery.
• Implemented Transparent data encryption, decryption, EFS and Auditing on all production servers for security compliance.
• Configured Snapshot and Transaction Replication for reporting users to use subscriber node as reporting server on non-prod servers.
• Installed and configured SQL Cluster and Always-On availability group on all production environment and routed reporting users to connect secondary node with read-only access.
• Decommissioned standalone server and kept all configuration backup on Azure BLOB for security purpose.
• Migrated data warehouse server from standalone to the cloud (Azure and AWS) as per the requirement.
• Designed and fine-tuned ETL solutions and TSQL’s and gained maximum performance.
• Implemented Power-shell script to monitor SQL and event viewer logs and generate Incident if needed.
• Configured Nagios alerts for database server alerts.
• Developed essential database alerts (Blocking, deadlock etc) to monitor database health regularly
• Created and scheduled database health report to monitor DMV statistics regularly, this helps us to find the root cause of performance issues and area of improvement
• Used DMVs, DMFs, Perfmon for identifying bottlenecks and resolving.
• Implemented standard checklist and review the code prior to deployment to avoid performance issue.
• Implemented CDC (Change Data Capture) and Change Tracking in SQL Server 2008/2012/2014 for capturing changes for a data warehouse environment.
• Designed, consolidated SSIS and SSRS server using Autosys and Load balancer technologies
• Implemented IN-MEMORY feature on report database to get maximum output.
• Analyzed and redesigned optimization query to improve performance as per application specific requirement
• Experts in Design, Architecture and providing solutions
• Involved in effort estimation for the requirements for the project.
• Designed and Fine-tuned SSIS packages that improved more than 60% of query performance.
• Initially loaded data into staging tables from Facets using different transformations, control flow tasks, loop containers, and data flow tasks, then moved the data into different Schema's.
• Investigated Data Discrepancies between Various Source Systems and the Data Warehouse that affect the flow of data through EDI for Government Compliance.
• Analyzed and fixed application workflow error and designed store procedure to cleaned workflow defects.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs.
• Integrated TFS with SQL data tools to manage MSBI stack packages properly in DEV, QA and PROD environments using check-in and check out and have maintained history for every minor change.
• Co-ordinate with all the business users and process owners to complete SDLC processes.
• Worked effectively with Business Analysts and Project managers for assigned tasks and deliverable timelines.
• Installed and configured MongoDB, PostgreSQL, and MySQL.
• Implemented and deployed replication in MongoDB.
• Configured multi-master replication on PostgreSQL.
• Created schema on Oracle RDS with appropriate permission.
• Migrated database to the different instance for development purpose.
• 24/7 Production On-Call Support.

Environment: SQL Server 2016/2014/2012/2008 /R2/2005/2000, Mirroring, Transactional-Replication, Windows Servers, Linux, Amazon Web services, Graphite, Service-now, JIRA, T-SQL, SSIS, SSRS, SSAS, SSDT, Oracle 11i/10g/9i, TFS, Confluence, lite Speed, XML windows Services, MS-Excel, MS Azure, MDW, SQL Server Replication, Business Objects,, Cluster Environments, Red Gate, CDC, TDE, Nagios, Active directory, Power-shell, IIS, IDERA, MySQL, MongoDB, PostgreSQL, Casandra.

Confidential

Sr. SQL Server DBA

Responsibilities:

• Database administrator support for SQL SERVER 2008R2/2012/2014 Production and non-production Environment.
• Analyzed, planned and migrated SQL server from On-Premises to Microsoft Azure network.
• Involved in migrating Application and processing servers and provided support for all databases related issues.
• Implemented transaction replication for very large database through database backup.
• Installed, configured and managed SQL server Always-On availability group.
• Applied all standalone database configuration to Azure database.
• Designed and deployed HA\DR backup and restore policy.
• Created and setup data-warehouse from scratch for analytics.
• Designed and deployed analysis cubes for data-warehouse.
• Developed Logi Analytics report using MDX query language.
• Involved in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
• Implemented SIDE BY SIDE Migration of databases from SQL Server 2000 to 2005 and SQL Server 2005 to 2008.
• Used native tools like DATABASE TUNING ADVISOR, PROFILER and ACTIVITY MONITOR for performance analysis.
• Handling Memory configurations for SQL Server 2000 and SQL Server 2005/2008 on Windows 2003
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snapshot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA, SQLCMD, and dedicated admin connection and Compressed Backups.
• Created Documentation for steps needs to be taken while upgrading the SQL server 2000 to SQL server 2005.
• Work-based on Business Intelligence (BI) and Data Warehousing in SQL Server 2005
• Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Migrated DTS packages to SSIS packages and maintained the archival data.
• Checking Database Health by using DBCC Commands and DMV’s.
• Monitored and modified Performance using execution plans and Index tuning
• Prepared Documentation for the Disaster Recovery plan, Worked in Active passive cluster environment
• Wrote and debugged Stored Procedures and (DDL /DML) Triggers, Functions as per client requirements
• Extensively worked on troubleshooting and fine-tuning of databases for its performance, Rebuilding indexes with different fill factors and update statistics manually
• Designed and implemented the comprehensive Backup plan and disaster recovery
• Worked extensively in Query analyzer and profiler for tuning queries using a variable for characteristics and query costs.
• Daily routine Developer/DBA tasks like handling user’s permissions and space issues on Production and handling maintenance Jobs including backups and restores.
• Hands on experience in troubleshooting database issues. Update statistics, database integrity check, and Backup operations
• Extensively used lite speed backup with MS SQL Server 2005/2008.
• Monitoring SQL server performance using a profiler to find the performance and deadlocks.
• Worked on call 24/7 Support on a weekly basis

Environment: SQL Server 2005/2008/2008 R2/2012/2014 and 2016 with clustering, Microsoft Azure, Replication, T-SQL, Windows 2008 and 2012, Perfmon, Tuning-Advisor, Logi-Analytics, crystal reports, Microsoft Silverlight, SSIS, SSAS, and SSRS.