OBJECTIVE:

I am a Microsoft certified SQL Server DBA with extensive experience in database administration, security, monitoring, designing, troubleshooting and performance tuning, seeking for a challenging position with a prospective and growing company to utilize and expand my technical knowledge, skills and expertise. I am an effective communicator with strong work ethic, exceptional relationship, excellent management skills and ability to relate to people at any professional level.

SUMMARY:

• Expertise in MSSQL Database Administration, installation, configuration, monitoring, performance tuning and maintenance with effective troubleshooting capabilities
• Strong technical ability to perform business analysis, write effective Runbook and specifications
• Clear concept about Cloud platform (MS Azure & AWS), it’s components and advantages
• Knowledgeable in T - SQL, stored procedures, triggers and functions
• Administer SQL Server high availability and disaster recovery solutions
• Skilled in ETL operations by SSIS using DTS, BIDS, SSDT and SSMA tools
• Worked on logical and physical data modeling with Toad and ERwin tools
• Experienced in using DMV and dynamic management functions for monitoring and queries optimization
• Exposed with SQL Clustering (active/passive, active/active nodes) and Always On Availability Group
• Experienced in SQL Server backup/recovery and security management operations
• Obtained experience in DR process including Log Shipping, Mirroring and Replication
• Experienced on SQL Server upgrade (in place and side/side) from SQL Server 2008 / 2005 to 2012
• Worked on SQL Server 2012 database migration from SQL Server 2008/2005
• Knowledgeable on 64/32 bit SQL Servers and Windows Server systems
• Managed both individual and group Windows service accounts related to SQL Server security management
• Familiar with Data Center Servers and handling VLDB databases
• Experienced in storage and table partitioning and capacity planning
• Handled memory configurations for SQL Server 2005, 2008 and 2012 on Windows 2003, 2008 and 2012
• Skilled in batch process, import, export, database monitoring tools and application support
• Implemented Linked Servers within SQL Servers & other Database platforms
• Strong knowledge and experience in Integration Services (SSIS) and Reporting Services (SSRS)
• Working knowledge in Data Masking and Data Encryption both in TDE and column level for Data security
• Experienced in mentoring, coaching and writing technical documentation and Runbook for future reference
• 24 X 7 SQL Database on Call Support

TECHNICAL SKILLS:

Databases: SQL Server 2014/2012/2008 R2/2005/2000, MS Access 2007/2003

Operating Systems: Windows 2012R2/2008 R2/2003 R2, Windows 7/8, VMware

App Environments: SQL, T - SQL, My/SQL, HTML, XML, JavaScript, ASP, PHP, C#, C++

ETL Tools: Native Tools (SSDT, BIDS, DTS and SSIS), SSMA

Reporting Tools: BIDS, SSRS (SQL Server Reporting Services) in HTML, Excel, Text, Email

Data Modeling Tools: ERwin, Toad Data Modeler, SSDD (SQL Server Database Diagram)

ThirdParty Tools: Red Gate, ERwin, Toad Data Modeler, SQL Sentry, ServiceNow, JIRA

Networks: Active Directory, Domain, DNS, TCP/IP, DHCP/LAN/HTTP/ HTTPS

Security: Data Masking, Data Encryption, TDE, Hardening

Storage: SAN, RAID, SSD

PROFESSIONAL EXPERIENCE:

SQL Database Specialist

Confidential, NY

Responsibilities:

• I maintain and administer SQL Server 2008R2, 2012 & 2014 in all Virtual environments using VSphere client
• I installed and configured SQL Servers 2012 and 2014 in Virtual machine for Dev, QA & HA environments
• I configured TempDB in all 2008R2, 2012 & 2014 instances according to baseline and business requirements
• I migrated Databases, Securities and Jobs to all new instances using both SQL native tools and scripts
• I configured & implemented Always-On Availability group (AIG) on SQL Server 2012/2014
• I Refresh Databases as needed from Prod to other environments for updated data analysis as necessary
• I wrote SQL scripts to Reinstate Database securities and permissions to its original form after Refresh process
• I work closely with developers to resolve any post issues related to Refresh and Security project
• I wrote SQL scripts to implement Backup/Restore, Remove DB-Security and Reinstate Security Dynamically
• I engage with Third-Party vendors and app-team for application upgrade project and its required process
• I wrote script for Data Masking to optimize Data security and privacy
• I performed Data Masking using script to support COTS application upgrade as assigned
• I verified Data security by Red Gate and by BU team prior to submission to vendor
• I have analyzed, researched and proposed economic DR/HA strategy with options for SSRS and SSIS Servers
• I realized security gaps and recommended a Security diagram to monitor DB/Server securities effectively
• I also proposed a Security metrics using script to help them find security loopholes both in DB/Server level
• I monitor Server activities and worked with internal clients to solve different problems as arises
• I suggest best practice to minimize SQL Server Capacity Management, Logfile and TempDB issues
• I proposed and implemented variety maintenance plan tasks to regulate any related performance issues
• I have create effective, detail and technical Run Books as future reference for all assigned projects

Environment:: Windows Server 2008R2, 2012R2, IIS 6.5, SQL Server 2008, 2008R2, 2012, AD (Active Directory), and applications in SAP, C#, ASP and Custom.

MSSQL-DBA

Confidential, Boston, MA

Responsibilities:

• I gained working knowledge in Data Encryption both in database level and in column level for data security
• Administered and managed SQL Server 2005 to 2014 in Development, QA and UAT environment
• Monitored and maintained Transactional Replication and Mirroring as current High-Availability solution
• Participated in SQL Server cluster and Always-ON configuration with the team
• Assisted with SharePoint Server upgrade from SQL Server 2008 to 2012 in QA and production environment
• Moved Data/Log files to different allocated drives in different servers related to upgrade project
• Assisted tech support team to apply SQL Sentry side/side upgrade from 7.0 to 8.0 on monitor servers
• Applied patch to SQL server 2008R2/2012 in Development, QA and Prod environment
• Analyzed the root cause of variety Database performance issues and resolved them time to time
• Utilized DBCC and DMV to check/monitor Database stats, validity, health and performance periodically
• Used SQL Sentry and SQL Profiler for database monitoring and performance in daily basis
• Monitored and shared ideas with development team to create, modify or update index (Cluster/Non-Cluster), constraints, views, stored procedures in query tuning for better performance
• Established E-R Diagram in SQL server 2005/2008 databases to build relationship between Heap tables which was migrated from flat files in COBOL language
• Exported & Imported data from Flat files to/from SQL Server Databases for immediate need
• Worked with reporting team to help generated reports using SSRS in Excel, HTML, Email or text format
• Implemented Replication strategy with central publication for high availability solution
• Resolved daily job failure related activities including backup, automation, performance and disk space
• Created different Maintenance Plans to monitor databases for better performance
• Solved various ticketing issues daily basis using JIRA as a third party tool and Foot-Print as customized tool
• Managed bottleneck, block, lock and deadlock when occurred
• Supported and managed a few production servers and any related issues with direct client
• Monitored and administered other SQL Servers/Databases daily basis and solved problems as needed
• Worked with PM, developers and vendors with ideas and solutions to meet project deadline

Environment:: Windows Server 2012, 2008-R2, 2003-R2, IIS 7.5, SQL Server 2014, 2012, 2008-R2, 2008, 2005, 2000, AD (Active Directory), and applications in JavaScript, ASP and ASP.net.

SQL Database Analyst

Confidential, Seattle, WA

Responsibilities:

• Installed, configured and maintained SQL Server 2008-R2 and 2012 in test and production environments
• Upgraded both in place and side/side from SQL Server older version to higher version
• Exported & imported data from Flat files to/from SQL Server database using Native Tools
• Exported & imported data from/to databases like Oracle, MySQL and Access to/from SQL Servers
• Migrated databases from other platforms to SQL Server 2008 R2/2012 using SSIS, BIDS and SSDT
• Installed and configured SQL Server Reporting Services (SSRS) to generate reports
• Configured and maintained Log Shipping and Mirroring as high availability solution
• Monitored Fail-Over Cluster nodes (active/passive) in SQL Server 2012
• Implemented table partitioning, file groups and capacity management for SQL Server 2008/2012
• Applied patch (Hotfix/Service Pack) on SQL Server instances as needed
• Exercised database query tuning time to time for performance issues
• I have working experience in creating and modifying table, index, constraint, view and stored procedure
• Worked with both database and application developers supporting in query optimization
• Generated data model, E-R diagram, reverse engineering, forward engineering using ERwin and SSDD
• Collaborated with team to generate reports using SSRS in different format
• Worked in database backup, restore and point in time recovery strategies and implementations
• Implemented different maintenance plans to scheduled jobs to automate different database related activities including backup, performance, optimization, disk space and memory usage
• Used third party tool ServiceNow for ticketing and fixed issues accordingly
• Monitored server activity, error log, space usage and solved problems accordingly per company policy

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

SQL Database Administrator

Confidential, Bohemia, New York

Responsibilities:

• Maintained and administered SQL Server 2000, 2005 and 2008 R2 in all environments
• Installed and configured SQL Servers 2005, 2008 and 2008-R2 in test and production environment
• Gained working knowledge with Active Directory and Windows Server (2003-R2 & 2008)
• Managed database Mirroring and Replication
• Worked with developers related to SQL, T-SQL, Stored-Procedures and triggers
• Assisted SQL developers with options to optimize SQL queries, Indexes and Stored Procedures
• Performed database monitoring, performance tuning, index and statistics management
• Monitored Server activities and worked with clients to solve different problems in daily basis
• Solved SQL Server error Logs, space usage, growth pattern issues as needed
• Analyzed root cause of bottleneck, lock/block and deadlocks and recommended strategy to minimize issues
• Created backup jobs for different types of backup like FULL, Differential and Transaction Log
• Implemented maintenance plan for tasks including index fragmentation, index rebuild and DB-statistics
• Worked on Data Modeling projects using Toad Data Modeler on designing Logical & Physical Database
• Created and managed Index (Cluster/Non-Cluster) and Constraints
• Created, implemented and managed security policy both at Database and Server level
• Planned, configured and monitored Log Shipping and Replication as disaster recovery option
• Installed and configured SQL Server Reporting Services (SSRS) and also developed basic reports using SSRS

Environment:: Windows Server 2008, 2003-R2, IIS 6.5, SQL Server 2008-R2, 2005, 2000, AD (Active Directory), and applications in C++ and ASP.

IT Analyst

Confidential, Melville, NY

Responsibilities:

• Installed, Configured, and Administered SQL Server 2000, 2005, 2008 in Dev and Prod environments
• Worked with Active Directory and Windows Server (2003 & 2008)
• Manage Database Log-Shipping and Replication as DR solution
• Worked with SQL developers regarding SQL queries, Indexes and Stored Procedures
• Performed database monitoring, index and statistics management
• Monitored Servers activity daily basis to maintain optimum level
• Supervised SQL Server Error Logs, space usage, growth pattern
• Managed BLOCK and LOCK
• Created Backup jobs for different types of backup like FULL, Differential and Transaction Log
• Generated maintenance plan for various jobs including index fragmentation, index rebuild and DB-statistics
• Assisted on Data Modeling projects with ideas to design Logical & Physical Database
• Created and Managed users, roles, security at object, Database and server level
• Implemented reports using SQL Server Reporting Services (SSRS) as needed
• Attended clients meeting with different issues and solutions

Environment: Windows Server 2008, 2003 R2, SQL Server 2008, 2005, 2000, AD (Active Directory) and applications in C++ and Java.