SUMMARY:

• Over 6+ years of IT experience which includes Experience in SQL Server Database Administration, Design, and System Analysis, Testing, Development and Support of MS SQL server 2017/2016/2014/2012/2008 R2/2008.
• Manage and maintain database changes in Development, QA, Staging and Production.
• Installed and Configured SQL Server in PolyServe Environment.
• Experience in installing Service Packs for SQL Server and OS.
• Experience in Installing and configuring SQL Server Active/Active and Active/Passive clusters with multi - instances.
• Extensive experience in Installation, Configuration and Upgrading of Oracle Server, Client Software and related products for Production, Development and Test Environment
• Implemented Database Mirroring with high-performance and high-safety mode.
• Implemented log shipping as a part of Disaster recovery solution.
• Implementing different types of Replication Models such as Transactional, Snapshot and Merge data replication to a multisite setup in SQL Server 2012 and SQL Server 2008R2 in OLTP environments .
• Immense experience in the manual failover & fail back process to make the DR server as the active server.
• Knowledge of high availability architecture including clustering and Always- On
• Extensive experience in Batch processes, Import, Export, Backup, Sql Loader, Shell scripting, Cron Jobs, Database Monitoring tools and application support.
• Extensive experience in controlling the user privileges, monitoring the security and Audit issues.
• Extensive experience in creation and maintained of PL/SQL Procedures, Triggers, Cursors, Views, Functions and Packages and created Cluster/Non-Cluster Indexes, join statements for applications
• Experience in configuring and managing Linked Servers, data transfer between SQL Server and other heterogeneous relational databases such as Oracle, OADAC and DB2 as well as native data sources
• Experience with SQL database development and working with developers in web based environment.
• Experience with SQL encryption technologies, PowerShell, DRaaS/cloud, third party monitoring tools preferred.
• Highly experienced in migration of data using BCP Utility, Bulk Insert commands, SSIS and DTS Packages, Import/Export Wizard and Copy Database Wizard.
• Extensive experience in space allocation, database migrations and database security.
• Implemented and documented proactive monitoring scripts for production databases.
• Expert in MS SQL Server Database Administration and Implementation
• Experience in contacting Microsoft PSS and other vendors for product and technical support.
• 24x7 Production support on call support.
• Microsoft Certified IT Professional: Database Administrator
• Microsoft Certified Professional: SQL Server 2014 Certified .

TECHNICAL SKILLS:

Database: SQL server 2017/2016/2014/2012/2008 R 2/2008/2005/2000. Oracle 10g, 9i,8i MS Access. Composite.

Technologies and Tools: SQL Navigator. SQL server Management Studio/Enterprise Manager, Crystal reports, SSRS, SSIS, SSAS, SSMS, Enterprise Manager, TOAD, Erwin Visual Studio 2005/2008. QuestLite,Speed,Tivoli,veritas,.net,backup,Log, analyzer,DB Artisan.

Operating Systems: Window 2003 Server 32 - bit/64-bit. Window 2008 Server 64-bit. Windows Server 2008R2 64-bit.

Programming Language: SQL, PL/SQL, VB.NET, VB Script, Python

Web Technologies: ASP.NET, HTML, DHTML, XML, IIS 6.0

Remote Software: VNC Viewer, Remote Desktop, VPN, Citrix Remote Access

Networking: TCP, IP Addressing and sub netting, static and dynamic routing, switching.

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

SQL Server DBA

Responsibilities:

• Perform system optimization and improvement planning, including, SQL Server database performance monitoring and analysis, capacity planning, system sizing and ongoing maintenance and tuning to ensure maximum performance.
• Create and maintain scripts and documentation for all aspects of administration including database design, implementation, data archiving, data scrubbing, encryption, disaster recovery, and participate in disaster recovery process.
• Support of large databases, including, availability monitoring, security, general database maintenance like data and log file management, extract transformation-load, backup/recovery, documentation, and configuration
• Planning and implementing a SQL Server backup design by taking several aspects of business in to consideration like Recovery-Point-Objective (RPO) and Recovery-Time-Objective (RTO).
• Provide technical and operational database administration for MS SQL Server in Dev, Test and Production environments which include quarterly username and password rotation of application accounts which has access to SQL databases as a part of PCI compliance.
• Providing performance and tuning by addressing various possible performance issues like deadlocks, blocking, missing and unused indexes, I/O bottlenecks, poor query plans, statistics, fragmentation by using SQL tools/resources such as Dynamic Management Views (DMVs), Profiler, windows performance monitor, built in performance monitor in SSMS, query plans, Database Tuning Advisor .
• Perform daily monitoring of servers including, but not limited to disk space monitoring, DBCC CHECKDB reports to check for any database corruptions and provide proactive issue resolution.
• Part of on-call rotation, including nights and weekends as needed

Confidential, Boston, MA

SQL Server DBA

Responsibilities:

• Installing, configuring and deploying SQL server 2014 and SQL server 2012 in clustered and stand-alone environment.
• Worked on a PCI security project that will be handling sensitive data information and securing databases in TDE SQL Server environment.
• Capacity planning for various server instances and databases on production and non-production environment with size ranging from 500GB to 3 TB
• Provide Database Administration and Support for SQL Server 2008,2008R2, 2012 and 2014
• Involved in deployment of builds to various environments for development and testing prior to deployment to production
• Configuring security and access per SOX and PCI standards.
• Creating Linked Servers for OLEDB Data Source and Native Sources.
• Monitoring MS SQL Server performance using performance monitor and profiler.
• Tune slow running queries using SQL Server Profiler.
• Import data across multiple instances using BULK INSERT and BCP Utility.
• Implementing SQL server agent jobs, monitor SQL server job history.
• Redesigning the Replication topologies during the upgrade and migration process.
• Configuring Policy-based Management to enforce policies across SQL Server Enterprise.
• Create and manage database objects that include Tables, Views, User-defined Functions, Stored Procedures,

Confidential, Houston, TX

SQL Server DBA

Responsibilities:

• Upgrading and Migrating SQL Server 2008R2, SQL Server 2012 on WINDOWS 2008/2008 R2 servers, applied service packs and security fixes in Clustered and Standalone environments.
• Configure, patch, test, monitor, and support multiple heterogeneous database instances, maintaining the databases at current release and maintenance levels.
• Installing SQL Server 2014 on sandboxes for testing purposes.
• Configured Transactional replication between primary servers and read only server, with separate Distributor server and experience in troubleshooting replication problems.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Troubleshoot Blocking and Deadlocking issues by making appropriate changes to Transaction Isolation levels and the types of locks being held; avoiding keeping transactions open for long durations, breaking large transactions to smaller ones.
• 24 X 7 Production Database On Call Support.
• Supporting multi-instance in analysis services and configuring different server modes on multiple instances on the same server as a part of instance management.
• SQL Query Performance Tuning, system Performance Analysis, analysing the Query Execution Plans, Used SQL Profiler for optimizing the store procedure.
• Helping Development Team in deploying and testing the application, which uses SQL Server as a database.

Confidential

SQL Server Developer

Responsibilities :

• Actively participated in gathering of User Requirement and System Specification.
• Filtered bad data using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistency Data entry into the database.
• Created reports from database onto excel spreadsheet-using DTS.
• Implementation of data transfer through DTS and setting guidelines to automate recovery scenarios.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity
• Tuned the SQL queries using SQL profiler.
• Checks, Update Database Statistics and Re-indexing.
• Created Users and Roles, and managed security and permission of database.
• Managed and resolved design issues during development
• Used SQLCMD utility in command prompt to access SQL Server.
• Created Partition View by using Linked Server for Business Requirement.