SUMMARY

• Microsoft certified senior SQL Server database Administrator with 8+ years of experience in planning, designing, implementing SQL Server databases, performance tuning, setting up and managing high availability and disaster recovery (HADR) solutions
• Experience in SQL Server database administration with various industries like communication, Banking and IT Consulting Companies
• Provided 24 X 7 dedicated supports for production database servers
• Installed and configured different versions of SQL Server (SQL Server 2005, SQL Server 2008R2, SQL Server 2012, SQL Server 2014 and SQL Server 2016) in non - prod and prod environments
• Monitored, fine-tuned and trouble shot performance issues in test, development and production servers
• Configured and applied SQL Server Service Packs and Hot Fixes to all Production and non-prod database servers
• Created maintenance plans for consistency checks and maintained indexes and statistics
• Planed, designed and Implemented two and three node clusters and configured MS SQL on the clusters
• Worked on daily activities like jobs monitoring, space alerts, troubleshooting, backup verification and jobs scheduling
• Highly motivated and committed Dev Ops Engineer experienced in Automating, Configuring and deploying instances on AWS, Open Stack cloud environments and Data centers
• Planned, Implemented and managed HADR solutions like log shipping, mirroring, clustering, Replication and Always on
• Implemented and configured transactional replication for reporting instance as subscriber for production use
• Have an excellent experience in Creating Views, stored procedures and other database objects using T-SQL
• Created SSIS packages for maintenance and data extraction, transformation and loading (ETL).
• Created reports using SSRS for different purposes
• Worked with SQL server Profiler, and generated traces to optimize the performance of the database
• Have extensive experience in using several third-party tools to monitor and optimize the performance of prod and Non-prod servers
• Programming experience in Python
• Performed index maintenance based on the fragmentation level of various tables
• Resolved locking and blocking issues and worked on active directory
• Planned and modified permission issues in the production servers and provide only the minimum required permission to the users on production database systems
• Assisted other teams in pointing out bottlenecks, and recommended solutions
• Profound understanding of Software Development Life Cycle
• Implemented and maintained policies, procedures and standards to ensure security and integrity non-prod and production data
• Experience in upgrading and migration from MS SQL Server 2005 to MS SQL Server 2008R2, MS SQL Server 2008R2 to MS SQL Server 2012 and MS SQL Server 2012 to MS SQL Server 2014
• Deployed different applications using PowerShell
• Worked on virtualizing the physical servers using VM-ware.

TECHNICAL SKILLS

Relational Databases/BI Tools: SQL Server 2016/2014/2012/2008/2005/2000/7.0, MS-Access 2000/2003/2007, Oracle 9i & 10g, Cold Fusion, My SQL4/5, OBIEE 10.1.3.x, Tableau 9.0/8.2.

Database Tools: SQL Server Enterprise Manager, Query Analyzer, SQL Profiler, SSIS, SSAS, SSRS, DTS, SQL OLEDB, Business Intelligence Studio, Crystal Reports.

Languages: C, C++, C#, VB.NET, ASP.NET, XML, UNIX Shell, Python, T-SQL.

Operating Systems: Windows 2012, Windows 2008 R2 server, Win ME/NT/XP, UNIX.

Web Servers: IIS 5.0/6.0, Apache, Tomcat.

Architecture: Relational DBMS, Client-Server Architecture, Clustering, Replication, OLAP, OLTP.

Cloud: AWS, Oracle HCM Cloud

ETL: SSIS, DTS, Informatica, Data Stage.

Other Tools: Erwin 4.0/3.5, Microsoft Visual Studio 2003/2005, Service Center, MS Visual SourceSafe, Source Control, MS Visio, Windows System Monitor.

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

Sr. SQL Server Database Administrator

Responsibilities:

• Responsible for planning and implementing all the SQL Server’s Data Center Migration from Moni old data center to New Data Center with Zero production down time
• Build New Clusters and migrate existing SQL Servers to New Clusters and Switch the production environment to New Servers as per the Migration planning steps
• Experience Working on Active/Passive clusters manage cluster resources and troubleshoot errors
• Used log shipping, Always on Availability Groups and Mirroring for synchronization of databases. Worked with Transactional Replication to achieve Load balancing
• Active involvement in installing and managing multiple two node failover cluster set up in active/passive environment as a High Availability mechanism
• Successfully implemented database mirroring with high availability mode in SQL Server 2016/2012.
• Configured transactional Replication from multiple subscribers for reporting purpose
• Involved in performance tuning, optimization of stored procedures and queries
• Successfully implemented Always on Availability group in SQL 2016/2012 and installed SQL Server in a cluster Environment
• Developed automation framework for Application Deployments to the cloud environments
• Configured DB mail for sending automatic mails to respective people when SSIS process fails.
• Migrated DTS packages to SSIS 2012/2016 packages
• Administered the MS SQL Server by creating User Logins with appropriate Roles, dropping and locking the logins, monitoring the User Accounts, granting and privileges to users
• Responsible for meeting with customers, determining requirements, communicating the requirements to the internal architectural team and managing the overall implementation to make sure all groups are working toward a single goal
• Work closely with developers and database team members to design, develop and enhance Microsoft SQL Server 2005/2008/2012/2016 database solutions
• Proactively resolves database performance, capacity, security, replication, back-up, and similar data issues within SLAs
• Reviews and deploys database objects or data changes in a Production and UAT environment
• Administers existing Production, UAT, and Development SQL Server environments
• Writes code for database access, modification and construction including stored procedures
• Implements and supports Enterprise compliant backup and recovery policies
• Lead and participate in reviews and quality assurance processes to ensure that the data architectures and standards are being adhered to. Enforce policies and procedures to team members
• Maintain documentation of DBA operational policies and procedures
• Participates in an on-call rotation to provide 24/7 Production support.

Environment: SQL server 2016/2014/2012/2008 R2/2005, SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Data warehouse, T-SQL, HTML, Microsoft Visual Studio 2012, Microsoft Silverlight, Tortoise SVN, MS Office communicator, Share point server, Windows 2008, Oracle Cloud HCM.

Confidential, Jersey City, NJ

Sr. SQL Server Database Administrator

Responsibilities:

• Participated in client requirement sessions to analyze and gather business requirements
• Involved in the Analysis, Design, Coding and Testing of the application and participated in discussion meetings about requirements
• Involved in logical and physical database design.
• Developed ER Diagrams, Data flow diagrams based on the requirement
• Developed SQL scripts to create database objects like tables, views and sequences
• Wrote complex PL/SQL queries and performed data analysis
• Created and Modified PL/SQL Triggers, Procedures, Functions and packages
• Extensively used for all and bulk collect to fetch large volumes of data from table
• Used SQL*Loader to load bulk data from various flat files and legacy systems
• Developed SQL and PL/ SQL scripts for transfer of data between databases
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables
• Optimized long running application queries, analyzing tables, tuned stored procedures for maximum efficiency in various schemas across databases
• Worked extensively on performance tuning and Query Tuning (Generating Plan Table, Explain Plan, optimizer with Hints, Analyze, Indexing strategy, SQL Trace, TKPROF, AWR and ADDM reports)
• Designed the PL/SQL Procedures to load data from Flat files and Oracle into the target Oracle database
• Developed UNIX shell scripts to automate data extraction using VI editor, SQL scripts and PL/SQL scripts Scheduled all the shell scripts in crontab and monitor them by logging them in to a separate table
• Worked on the integration on various legacy systems to the main process which included the data migration and maintenance
• Worked on data imports / Exports, Data pumps, SQL Loader
• Worked on Database Design, Data Modeling, Migration, and Systems Architecture, Planning, Testing Query Optimization and Trouble Shooting
• Involved in Code Review and User Acceptance Testing (UAT) of the application
• Understanding the process and Interacting with functional team to resolve the issues in the given objects
• Was responsible to update and maintain all process related documents and coordinate the effort within teams
• Helped in maintaining an effective documentation process to track the version control and requirement changes.

Environment: MS SQL Server 2012/2008R2/2005/2000, T-SQL, SSIS, Lite Speed, BCP, SQL Profiler, Replication, Log shipping, Mirroring, Clustering, Windows XP/2000 and Windows 2003/2008 Server, Oracle 10g, C#, .net, Oracle 9i, AIX, Solaris.

Tech Democracy. Edison, NJ

Sr. SQL Server Database Administrator

Responsibilities:

• Created tables, indexes, constraints and Views to facilitate easy user interface implementation, and triggers on them facilitate consistent data entry into the database
• Designed automated scripts in T-SQL, DTS, and BCP to import data from various ODBC sources into SQL Server databases to maintain the consistency and data integrity
• Actively monitored performances of queries on SQL server using SQL Profiler and optimized it by creating appropriate indexes using Index Tuning Wizard by using SQL Data manipulation language
• Good experience on working with Extract, Transform and Load (ETL) tool
• Created SSIS packages to migrate data from Oracle DB to SQL Server 2008
• Created Jobs, Alerts and scheduled DTS Packages and SSRS to generate reports
• Database and log backups and restoration, backup scheduling the backups. Backing up master and system databases and restoring them
• Developed SSIS packages to extract and transform data and Involved in Scheduling SSIS Packages
• Using SQL Server Integration Services (SSIS) to populate data from various data sources using the concept of OLE DB
• Developed SSIS packages and deployed into Dev, Test and Production Environments
• Query optimization and performance tuning. Writing triggers and stored procedures and optimizing it
• Managing the use of disk space, memory and connections
• Performed software installation and upgrade, capacity planning
• Ensured developers coordinated their efforts in managing and maintaining different application databases
• Eased administrative work through automatic script performing daily/weekly backups
• Reduced systems downtime risk through automatic offsite backup and recovery over network
• Responsible for database security of the operational and developmental application system databases
• Performed DBCC checks which will helps to maintain physical consistency of the database.

Environment: SQL server 2008 R2/2005, Microsoft Visual Studio 2008, Win 2003, Embarcadero DB Artisan 8.5, BMC Remedy AR system, Microsoft Visual Source Safe, NHibernate, Viper, Office communicator, share point server, Power Designer View, Change Control Manager.

Confidential, New York, NY

SQL Server Database Administrator

Responsibilities:

• Installation of SQL Server of versions 2014, 2012 & 2008 on Windows 2012 R2 & 2008R2 in cluster and standalone environments
• Configuring SQL Server Always on Availability groups and monitoring them with the help of user-defined policies along with the built-in policies on SQL Server
• Created SQL Jobs to schedule SSIS Packages
• Worked with various tasks of SSIS include Transform Data Task, Execute SQL Task, Active Script Task etc.
• Created packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server
• Fine-tuned database server clusters, migrated all databases to clusters while conducting recommendations for compression, partitioning for disaster recovery, code refactoring, and base lining and monitoring all systems
• Performed database tasks like reorganizing and rebuilding indexes, index tuning for performance
• Loading the data using Dynamic SQL and PowerShell
• Maintain, build, and support production, development, and test SQL Server environments including OS configurations
• Monitored the servers and Linux scripts regularly and performed troubleshooting steps - Tested the latest software on server for end-users
• Retrieved data from data warehouse and generated a series of business reports using SSRS
• Troubleshoot SQL Server Failover Cluster Instances
• Implement and maintain MySQL/ SQL Server database security
• Resolving the alerts related to Native and TDP TSM backup jobs
• Maintained existing programs/scripts and extended Linux system functionality as needed
• Write advanced queries, create/modify schema, stored procedures, functions, triggers and views.

Environment: Windows 2008 R2, Windows 2008, Windows 2003, SQL Server 2008R2, SQL Server 2008, SQL Server 2005, SQL Server 2000, HP-UX, AIX, Solaris, Oracle9i, Oracle 10g, REDGATE.

Confidential, Pittsburgh, PA

SQL Server Database Administrator

Responsibilities:

• Installed and Configured SQL Server
• Updated MS SQL Server 2012 to MS SQL Server 2014
• Migrated data from old version of MS SQL to latest version
• Created Tables, Views, Indexes and other SQL joins
• Developed T-SQL (DDL, DML) statements, and Data Integrity constraints
• Conducted Performance Tuning and Query Optimization
• Solved Validation issues
• Used Index Tuning Wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning SQL Server Performance
• Worked on maintenance tasks like Patching, running Scripts and scheduling them in Task Manager
• Created Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications
• Migrated Data from old versions of MS SQL
• Implemented Load balancing Replication across the Databases
• Performed Database Refresh tasks from Production to Development and Staging Servers
• Configured High Availability and Disaster Recovery (HADR) methods including Mirroring, log shipping, clustering, and Always on availability groups
• Connected, imported, shaped, and transformed data using SSIS for business intelligence (BI)
• Deployed the created SSIS packages in Development and Testing environments
• Created SSRS reports using complex SQL Queries/Stored Process which have sub-reports, Drill-Down reports and charts
• Visualize data, author reports, and schedule automated reports using SSIS/SSRS
• Performed index maintenance at regular intervals for better performance
• Developed SSIS packages to extract, transform, and load (ETL) data from/into different sources
• Created data sources, connection strings and defined the datasets for generating reports report
• Created Views, stored procedures and other database objects using T-SQL.

Environment: MS SQL Server 2014, 2012, 2008R2, SSAS, Clustering, Replication, Visual Studio 2008, SQL Server Profiler, PowerShell.

Confidential, Horsham, PA

SQL Server Database Administrator

Responsibilities:

• SQL Server Setup, Installation and Version Upgrade
• Handling an enterprise level setup for the client and managing Replication issues, Jobs management, Log
• shipping, clustering and client issues regarding infrastructure including security etc.
• Deploying the database builds using MS Build, Octopus and Autopilot tool
• Migrated Databases from SQL Server 2005 to SQL Server 2008r2
• Updated with latest service packs and security patches
• Administered Regular Database Backups, Restoration, Performance tuning, backup processes
• Provided Database Support for various production applications in resolving complex issues
• Involved in Disaster Recovery procedures, and Contingency plans. Testing and implementing procedures
• Worked closely with clients, business analysts, systems programmers, and application developers to define and resolve information flow and content issues
• Rebuilding the indexes at regular intervals for better performance
• Used DBCC commands to check the database consistency
• Support for very large SQL Server databases with 24x7 limited downtime availability
• Use MS Product Studio for bug reporting.

Environment: Microsoft Windows Server 2008/2003 32/64-bit, Microsoft SQL Server 2008, R2, Event Viewer, SQL Profiler and Quest Lite Speed.