SUMMARY

• Expertise in Database Administration in server configuration, monitoring, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Strong technical background along with teh ability to perform business analysis and write TEMPeffective documentation and specifications.
• Expertise in T - SQL writing stored procedures, triggers and functions.
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations.
• Implemented teh new SQL Server 2012 mechanisms like data compression, online indexing, Contained Databases, security TEMPprincipals and AAG.
• Worked on logical and physical data base modeling with UML and ERWIN tools.
• Experienced in using DMV and dynamic management functions for finding out long running queries.
• Worked briefly on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
• Experienced in Disaster Recovery Planning and Security Management operations.
• Proficient and skilled in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Having hands on experience in DR processes including Log Shipping and Database Mirroring.
• Worked on configuring SQL Server with minimum privileged access.
• Skilled in troubleshoot performance problems, fine-tuning of databases and index Analysis.
• Worked on SQL Server 2012 migration from SQL Server 2008 / 2005.
• Experienced on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations.
• Implemented Always-ON (AAG) on SQL Server 2012 SP2 CU5
• Maintained individual service accounts for SQL Server.
• Has experience on Data center servers and handling 1.4 TB databases.
• Handled Memory configurations for SQL Server 2014 and SQL Server 2012 on Windows 2012.
• Skilled in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also created DTS package for data transfer between teh two environments.
• Working knowledge in Analysis Services (SSAS), Reporting Services (SSRS) and Clustering.
• Experienced in training, mentoring team members and writing documentation.
• 24 X 7 Production Database on Call Support.

TECHNICAL SKILLS:

Database: SQL Server 2012/2008R2/2005/2000, MS Access 2007 & 2003

Operating System: Windows Server 2012/2008 R2/2003 R2/2000, Windows XP/7/8, MS - DOS, UNIX/Linux, VMware

Languages: SQL, T-SQL, PL/SQL, HTML, DHTML, XML JavaScript, ASP, ASP.net and C++

ETL Tools: SSIS and DTS

Reporting: SSRS (SQL Server Reporting Services), Excel

Data Modeling: ERWin, Visio, Toad Data Modeler, SSDD (SQL Server Database Diagram)

Third-Party Tools: Idera, SpotLite, ERWin, Visio, Toad Data Modeler.

Networking: Active Directory, TCP/IP, DHCP/LAN/HTTP/ HTTPS

Hardware/Storage: SAN, RAID

PROFESSIONAL EXPERIENCES:

Confidential, Seattle, WA

SQL Database Administrator/DBA

Responsibilities:

• Installed, Configured, and Maintained SQL Server 2012, and 2008 R2 in development, test, and production environment
• Installed, Configured and Maintained Fail-Over Clustering using SQL Server 2012
• Installed and Configured SQL Server Reporting Services (SSRS)
• Configured and Maintained Replications, Log Shipping, and Mirroring for High Availability.
• Upgraded databases from SQL Server 2005 to 2008 R2/2012 and 2008 R2 to 2012in testing and production environment
• Migrated MS Access 2003/97 databases into MS SQL Server 2008 R2
• Migrated Oracle 10gR2 and MySQL 5.1.23 databases to SQL Server 2008 R2 and 2012
• Applied SP (Service Pack) on SQL Server Instance as needed
• Time to time on database Performance tuning
• Utilized DBCC to check database conditions and Rebuilding indexes as well
• Strong working experience in creating, modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers
• Worked with developers for different purposes like writing queries, halped in writing queries, and in tuning queries
• Data Modeling, developed E-R Diagram, Reverse Engineering, Forward Engineering using ERWin and SQL Server Data Diagram
• Export & Import data from Flat file, CSV file to/from SQL Server Database using DTS, SSIS, and BCP
• Export & Import data from/to databases like Oracle, MySQL, and Access to/from SQL Server
• Generated Report using SSRS and in Excel, html, and text as well
• Excellent working experience in Database Backup, Restore and Point in Time Recovery.
• Working experience and strong knowledge in High Availability and Disaster Recovery
• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification
• Developed Different Maintenance Plans for database monitoring
• Monitor Server Activity, Error Log, space usage and solving problem as needed

Work Environment: Windows Server 2012, 2008 R2, IIS 7.5, SQL Server 2012, 2008 R2, AD (Active Directory), and applications in J2EE, ASP, and ASP.net

Confidential, Bohemia, New York

SQL Server DBA

Responsibilities:

• Migrated and Upgraded from SQL Server 2005 to 2008 R2
• Configured database software, associated database tools and performance monitoring software.
• Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
• Performed acceptance testing to verify dat database changes perform without adverse consequences.
• Customized support for Client’s Applications and provided client will won teh responsibility of creating and maintaining database objects and structures such as tables, indexes, views, triggers, functions, procedures.
• Developed & maintained scripts, utility jobs or implement needed software for database maintenance.
• Implemented & managed database clustering, failover and load balance technologies as per client requirement.
• Developed, tested & implemented a robust database backup and recovery strategy with client assistance.
• Monitored data activities such as database status, logs, space utilization, extents, checkpoints, locks and long transactions.
• Suggested Application level tuning changes for code, queries, SQL objects dat may not be performing up to teh optimum database performance standards.
• Set up security and access profiles and procedures for database system administrators.
• Implemented MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster up to 8 Node.
• Handled Logical Data and Index partitioning for large tables in SQL Server 2005, & 2008 R2.
• Created, administered & maintained SQL Server Databases to Production, Development, Test and Staging Environment for various groups such as Developer, QA, BA, and User.
• Managed security by defining roles and rights.
• Handled Fine Tuning Operating System in-coordination with Server and Network Administrator to utilize teh maximum resources for Database and Applications.
• Monitored teh database server performance and if required go for tuning of teh TSQL queries, Stored procedures.
• Working individually, as a member of a team, and lead small teams to collaboratively design and model systems at a high level prior to construction.

Work Environment: Windows Server 2008 R2, 2003 R2, IIS 7.5, SQL Server 2008 R2, 2000, AD (Active Directory), and applications in J2EE, ASP, and ASP.net