SUMMARY:

• Database experience on platforms both traditional RDBMS (MS SQL Server) and NoSQL (MongoDB).
• 8+ years of Microsoft SQL Server Database Administration & Development experience in SQL Server 2016/2012/2008 R 2/2008/2005.
• 3+ years Mongodb (3.2 and 3.4) DBA experience in a large database environment.
• Experience with MongoDB scaling across data centers and/or in - depth understanding of MongoDB HA strategies, including replica sets and sharding.
• Manage and maintain multiple database servers across multiple environments.
• Experience in MS SQL Server 2012 with Business Intelligence in MS SQL Server Integration Services 2008, MS SQL Server Reporting Services 2008 and MS SQL Server Analysis Services 2008.
• Strong experience in Creating Databases and writing queries involving Stored procedures, User Defined Functions, Tables, Views, Indexes, relational database models and data integrity based on Functional requirements and System Design that meet the business and technical objectives.
• Experience in working with huge databases, VLDB, troubleshooting issues and documenting the causes.
• Solid understanding of database principles and practices in a complex client/server, distributed computing environment
• Installed and configured SQL Server 2012/2008R2 on new 32-bit and x64-bit Operating System.
• Highly proficient in database Backup, Restore, Recovery, Transactional Replication, Linked servers, and Database Maintenance Plans.
• Actively involved in System Performance by tuning SQL queries and stored procedures by using SQL Profiler, Database Engine Tuning Advisor, Windows performance monitor, DMVs, DBCC and Custom Script, Built in performance Report and Activity Monitor.
• Proficient in implementing different types of Replication models like Snapshot and Transactional.
• Proficient in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using SSIS, BCP and DTS utility.
• Successfully tested and implemented Log Shipping technique used for warm backup solution for MS SQL server 2008R2.
• Experience in Implementing Database Mirroring in SQL server 2008.
• Experience in Implementing AlwaysOn Availability Groups in 2012.
• Involved in Installing, Configuring and Maintaining of Cluster in SQL Server 2008R2 and SQL Server 2012 on Active nodes.
• Involved in Installing, Configuring and Maintaining of Cluster in SQL Server 2008R2 and SQL Server 2016/2014/2012 on Active nodes.
• Provide 24x7 production support for SQL Server databases on Clustered Servers with sizes ranging from 12 to 30 Terabytes to achieve maximum performance and uptime in production environment.
• Experience in upgrading SQL server software to new versions and applying service packs and patches.
• Documented Disaster recovery plans and participated in disaster recovery drills.
• Installed and configured SQL Server 2016/2014/2012 /2008R2 on new 32-bit and x64-bit Operating System.
• Experience in using Ticketing System Software Service Now and Remedy to track issues in Environment.
• Experience of opening a ticket with Microsoft Team for Technical Support to troubleshoot an issue.
• Develop and document best practices for maintenance, monitoring, migration, and fail-over strategies.
• Ability to meet deadlines, quickly adapt to different project environments and ability to work with different team across geographical locations.

TECHNICAL SKILLS:

E: Languages: C,C++,T-SQL,PL/SQL.Power shell, python and UNIX shell

RDBMS: MS SQL Server 2012, 2008 R2, 2008, 2005, 2000, Oracle11g, MS-Access.

Operating System: Windows NT 4.0, Windows 2000, Windows 2003.

SQL Server Tools: MSSQLServer Reporting Services (SSRS),MS SQLServer Integration Services (SSIS), Data Transformation Services(DTS),SQL Server Management studio (SSMS,Enterprise Manager, SQL Query Analyzer, SQL Profiler, Bulk Copy Program (BCP).

Other Tools: RED Gate and SQL Sentry, Quest Software SQL Lite Speed, Quest Software Spotlight, Quest Fog light

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, Tx

Sr. DBA

Responsibilities:

• L3/L4 DBA Support for MS SQL Server and Mongodb Databases
• Administer and Maintain the OLTP & DWH environments and provide day-to- day operational support.
• Support DBA activities in huge OLTP production environments.
• Database size varies between 500 MB to 14 TB (DEV-UAT-STAGE-PROD).
• Expertise in Always-on availability groups and HA\DR setup and configuration.
• Analyzing and designing and implementing different types of Replication Models.
• Work with Storage and Network team to build new SQL Servers.
• Working with Dev and Architect Team to implement SQL Server 2016 in-memory database and Tables on current Prod.
• Used ColumnStore indexes in BI servers.
• Expertise in Always-on availability groups (2014) and HA\DR setup and configuration.
• Created column store indexes on OLAP databases (2012 and 2014).
• Spreading huge tables to different file groups to achieve maximum performance.
• Writing TSQL code and complex stored procedures for different tasks. Tuning the code written by team members to achieve optimum performance.
• Setting up Disaster Recovery solutions using Log shipping, Mirroring, Always On (2012) in windows clustering environments for High Availability.
• Working on implementing in memory (2016) database and tables in current prod OLTP.
• Highly proficient in database columnstore, In memory, Alwayson, Backup, Restore, Recovery, Transactional Replication, Linked servers, and Database Maintenance Plans.
• Setting up monitoring alerts and dashboards in addition using of SQL built-in dashboards.
• Discussion with peers about performance issues, SQL Internals about log shipping, DB mirroring, replication etc.,
• MS SQL Server installation, configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
• Database creation, restoration, recovery, User/Schema Creation and maintenance Space Management.
• Monitoring and Troubleshooting SQL Server using Windows System Monitor, creating an Alert in Windows System Monitor, creating a SQL server Performance Alerts.
• Data migration (import & export - BCP) from Text to SQL server.
• Setting up High availability always on future on new 2012 servers.
• Good understanding and experience in SQL Server 2008 features like Change Data Capture (CDC), Transparent Data Encryption (TDE) and Policy based Management.
• Prepared and documented Backup & Restore Plans and manage data import and export form multi-agency interfaces
• Supported Application Development team with any database issues, updates or new releases. Support included deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results
• Created CPU, Memory, Blocking and long running alerts to study the queries causing these alerts and make suggestions to DB development team.
• Created good performance practice documents for developers to follow at the time of coding.
• Analyzed long-term databases performance trends to optimize database and application performance.
• Maintained documents and implement Disaster recovery models.
• Managed logins and user accounts, including assigning database object permissions and ancillary privileges.
• Resolving Locking and Blocking issues.
• Experience in creating, configuring and managing SQL Server database from scratch.
• Worked on 2/3 Node Cluster Environment and Installed SQL Server on Cluster Node in SQL server 2014/2012 and 2008R2.
• Applied SQL server Patches and CU4 on SQL server 2012 and 2014.
• Configured Mirroring with the witness server in Asynchronous Mode for High Performance of Database.
• Experience in Installing SQL server Failover cluster on windows server 2008 R2 along with troubleshooting Failover clusters.
• Experience in configuring Multi-Subnet Failover clustering.
• Supported high availability on a 24*7 production support basis.
• Multi datacenter environments.
• Clear understanding of relational and non-relational databasesMongoDB DBA Experience
• Experience working on MMAPv1 and WiredTiger Storage Engines.
• Improved query performance using explain () and make necessary changes to queries.
• Expertise Knowledge on purpose and types of indexes.
• Using profiler to understand slow query behavior in Dev environment.
• Good understand and experience setting up Replica sets (secondaries with Arbiter).
• Experience working on Backup and Recovery strategies.
• Thorough understanding and experience of server configuration both hardware and virtualized, and how it affects performance and cost.
• Thorough understanding and experience of sharding.
• Experience working with sharded cluster.
• Support DB dev team with Query analysis.
• Participate and recommend good practices for DB Schema design.
• Experience with TCP dump / mongosniff.
• Monitoring Mongo DB using OPS Manager.
• Experience with MongoDB Management Service (MMS)
• Worked along with security and system admin to setup user authentication and authorization.

Environment: SQL Server 2016/2014/2012 /2008, SSIS, SSRS, MongoDB, Quest Software SQL Lite Speed, Quest Software, Idera,OPS Manager, python, json, Visual studio 2008, MS Visio 2007, XML, VB.Net, Report Builder 3.

Confidential, Newark, NJ

Sr. SQL Server Database Administrator

Responsibilities:

• L3/L4 DBA Support for MS SQL Server databases.
• Lead SQL DBA Team (Offshore) for DBA Support Operations
• Installation, administration, up-gradation and patching of SQL Server databases for Prod, QAand Test Environment
• Support new SQL Server database builds and projects (includes Installation, Backups, Monitoring and Security Hardening.
• Deploy SQL Service Packs on Dev, QA and Prod Database Servers (SQL Server 2008, 2008R2 and 2012 ) on Virtual and Physical Servers
• Upgrade unsupported Versions of SQL 2000 & SQL 2005 databases to 2008, 2008 R2, and 2012 on Virtual and Physical Servers environment
• Configure, maintain and perform SQL database backup and restore operations via Redgate, Idera, and Litespeed for SQL Server.
• Manage Azure based OLTP & reporting environment.
• Manage backup, restore and migration for Azure SQL Server Databases supporting ETL operations
• To enable and deploy SOX compliances in Database Servers
• Representation for DBA team’s changes at the weekly/daily CAB
• To providing Risk and Compliance management services via RSA Archer for SQL Server.
• Develop and maintain geographic spatial queries to support GIS Applications.
• Implement, configure and monitor database mirroring & replication for production and QA databases
• To develop and maintain BI and Analytical reports & dashboards using SQL BI.
• Setup SQL Server Monitoring, jobs via SQL Agent, SSMS, Nagios XI Monitoring System and Idera
• Setting and implement SQL Server AlwaysOn High Availability for SQL Databases.
• Configure, maintain and support SSRS, SSIS and SSAS
• Performance tuning of MS SQL Server Databases via native tools (SQL Server Profiler, System Monitor, Perfmon, Task Manager, Activity Monitor & Database Tuning Advisor) and 3rd Party tools (NetIQ Idera & SQLSentry)
• Support new builds, releases, deployment & Source Code Management manually or third party tools.
• Installation, creation and maintenance of the MDW databases
• Drilldown Reports generation and maintain health of the MDW databases
• Shell, PowerShell, SQL & Perl scripting for automation of jobs and manual monitoring
• Design. model and build new databases via ER/Studio and Erwin tools
• Responsible for the administration of the SQL server system including installations, upgrades, performance, security, sizing, support and connectivity.
• Involved in Design and Development of Crystal & Microstrategy Reports
• Resolve moderate to complex (Sev1, Sev2 and Sev3) incidents and problems effectively and in a timely manner
• Responsible for performing rca and long term fixes
• Scripting in PowerShell, Perl and Shell for automating dba operations, alerts and monitoring
• Participate in Change Meetings and review and approve/get approval for DB related changes
• Database Cloning, restore and refreshes as per requirement
• Creations of SOPs, KT documents and Audit procedures for current project.
• Support end users, releases, incidents, changes and problem management via Remedy Ticketing System and MKS.
• On Call support to client during public holidays and weekends.
• Creations of support tickets with vendors Microsoft and other vendors for technical assistance against critical and unknown issues.
• Involved in Daily monitoring, Maintenance of SQL Server 2008 instances (64 bit) in the Development/Production Environment.
• Scheduled maintenance Jobs and Alerts using SQL Server Agent by creating database maintenance plans.
• Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
• Creating the clustered/non-clustered indexes on right columns of the tables; trace out for any tables that require for any indexes and determine the type of index on it.
• Perform Database Consistency checks by DBCC commands and Dynamic Management Views at regular intervals to check for fragmentation and torn pages in tables of databases and to improve the overall performance of the database.
• Verifying Index Fragmentation and performing reorganize and rebuild as per Percentage.
• To analyze long running slow queries and tune the same to optimize application and system performance. Performance Tuning of the Stored Procedures.
• Monitored and modified Performance using execution plans and Index tuning.
• Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
• Excellent hands on experience in SQL cluster installation and troubleshooting.
• Successfully Configured Snapshot and Transactional Replication.
• Created and managed maintenance jobs for performing SQL Backups, DBCC, and Index creation/recreation.
• Setup the performance counter by using performance monitor to identify the bottleneck of windows server such as CPU, memory, IO, paging and also bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc.
• Used Cyber Ark to store SA Password and Manage them
• Frequently monitored the performance issues on the production server.
• Generated various reports of the production servers to analyze the performance and to monitor any dead lock issues
• Created and implemented various partition plans on the large databases to overcome the size issues.
• Involved in migrating historical data to the Archiving server.
• Database Cloning, restore and refreshes as per requirement
• Creations of SOPs, KT documents and Audit procedures for current project.

Environment: Microsoft SQL Server 2012/2008/R2/2005/2000 Enterprise Edition with Clustering Windows 2003 Advanced Server, MS Access, SSIS, SSRS, MS Visio, SQL Profiler, Erwin., SQL SENTRY, Erwin, Cyber Ark, T-SQL, SSIS, SSAS.

Confidential

SQL SERVER DBA

Responsibilities:

• Upgraded SQL server from SQL 2000/2005 to SQL 2008/R2
• Worked as a team to maintain 100 percent up time to keep the environment running irrespective of any infrastructural changes in the environment.
• Implemented and Maintained DBA tasks like scheduling jobs, creating maintenance plans.
• Performed Permissions, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Worked migration tools like ATTACH/DETACH using excel.
• Created & maintained databases, users, Logins, tables, indexes, stored procedures, roles, permissions and other schema objects.
• Monitoring SQL server performance using profiler to find performance, dead locks, blockings and Capturing long running SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Responsible for Stored Procedures optimization, Performance tuning & index tuning.
• Provided necessary data validation checks against the data entry.
• Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Strong experience in handling Microsoft office suite like word, PowerPoint, excel to generate reports
• In Analysis Services (SSAS) OLAP created Cubes, Star Schema and Snow Flake Schema, ETL and Data Warehousing
• Utilized PowerShell to maximize SQL server productivity and efficiency.
• Derived and documented the Analysis for production issues in SSAS.
• SSAS native tools utilized to generate reports in Microsoft Visual Studio
• Implemented Always ON High Availability in SQL Server 2012
• Worked on call 24/7 Support on weekly basis.

Environment: SQL Server 2000/2005/2008/2008 R2 with clustering, Replication, Log shipping, Mirroring, TSQL,Windows2003/2008R2,BugZilla,DTS,SSIS,RedGate,Profiler,SQLSentry,Sharepoint,IBMDB2,TSM,TFS,LiteSpeed,SVN.