SUMMARY

• Over 7 years of IT experience in MS SQL SERVER 2005/2008R2/2012 Administration (DBA) in windows environment.
• Excellent knowledge in Relational Data Base Management System.
• Well experienced in Installing, Configuring, and upgrading SQL Server.
• Experience in Migrating from SQL server 2008R2 to 2012by using side - by-side upgrade process, and documented the Upgrade Process.
• Expertise in implementing efficient Disaster Recovery Strategies and High availability like Replication (Snapshot, Transactional, and Merge), Log shipping, Clustering (Active/Active and Active/Passive), AlwaysOn and Database Mirroring.
• Experience in implementing and managing transactional, merge, and snapshot Replication models.
• Experience in establishing routines to ensure that indexes are defragmented regularly and statistics are up-to-date.
• Best practice implementation including maintenance plans, Jobs scheduling and notification, proactive monitoring and alerting.
• Expertise in using DBCC trace flags, handling blocking and deadlock situations.
• Experience in monitoring and tuning SQL Server database performance using SQL Profiler, DMV’s, DMF’s, Index Tuning Wizard and Windows Performance Monitor.
• Experience in resolving issues and identify root cause and proactively improve the reliability of the data
• Expertise in creating and managing databases and users. Evaluating user permissions and granting access to authorized users using least privileges policy.
• Good understanding of Normalization /De-normalization, Normal Form and database design methodology. Excellent skills in database backup, recovery, and Log Shipping.
• Experience with Integration Service (SSIS), Analysis Service (SSAS), and Reporting Services (SSRS) installing, configuring, deploying, migrating, scheduling jobs, importing and exporting.
• Experience with third Party tools like Redgate and Spotlight.
• Very good communication, conceptual, analytical, writing and documentation skills

TECHNICAL SKILLS

Databases: MS SQL Server 2005, 2008R2, 2012

Database Tools: Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Upgrade Wizard and Database Tuning Wizard.

Programming: T-SQL, C

ETL Tools: SSIS

Backup and Monitoring: Spotlight, Redgate, Fog Light

Operating systems: Windows 2003 and 2008 servers

PROFESSIONAL EXPERIENCE

Confidential, Newark, NJ

SQL Server DBA

Responsibilities:

• Installed and Configured SQL Server 2012 Servers in Production Environments and migrated SQL Server databases from SQL Server 2008 to SQL Server 2012.
• Performed side by side upgrade wherever it was needed and documented the process.
• Setup ALWAYSON for critical database as a High Availability Solution.
• Created various availability groups depending up on the requirements of the particular databases
• Created and managed clustering environment such as active/passive clustering.
• Built and maintained SQL Server failover clustering and single cluster node solutions for specified applications.
• Created databases, logins, roles and granted appropriate permissions.
• Created jobs, alerts, activity logs, error logs to capture any possible errors.
• Created Database Maintenance Plan for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Supported 24*7 production support and solved all kinds of critical problems.
• Participated in SDLC methodologies such as planning, analysis, design and implementation.
• Setup, implement, and maintain industry standards in database management.
• Leverage Performance Tuning and Optimization, using native monitoring and troubleshooting tools.
• Worked well with team members to bring the databases up to the business requirement.

Environment: T-SQL, SQL Server 2012, OLTP, ALWAYSON, SSIS, Replication, Windows 2008, Redgate and Spotlight.

Confidential, San Jose, California

SQL Server DBA

Responsibilities:

• Identify long running queries using profiler and tune them using various techniques to improve performance.
• Identify top 10 slow running stored procedures and tune them.
• Identify long running jobs and improve their performance. One of the jobs that I tuned to less than 15 minutes was running for 22 hours.
• Identify heap tables across all databases and implemented clustered indexes with or without primary key.
• Using indexes, fine tuned databases to perform query faster.
• Worked with developers to tune their stored procedures in the development stage before released to production.
• Worked with DTA to improve performance of queries by implementing indexes to the missing tables.
• Monitoring SQL server performance using profiler to find performance issues and deadlocks.
• Monitoring the servers using Spotlight third party Quest software.
• Created Triggers to enforce data and referential integrity.
• Worked with others in IT to build the logical database area and provide technical guidance during all phases of the development process.
• Work with Product Managers and a development team to implement integrated solutions with various technology platforms between internal technologies & outside vendors.
• Supported 24/7 support to the team members and other clients on call during business and non-business hours.

Environment: SQL Server 2008 R2, Transact-SQL, Enterprise Manager, Query Analyzer, SQL Profiler, SSIS, Spotlight.

Confidential, Palo Alto, CA

SQL Server DBA

Responsibilities:

• Migrated SQL Server databases from SQL Server 2000/2005 to SQL Server 2008 R2 and installed patches and service packs for the SQL Server 2008 R2.
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 R2 as SSIS packages.
• Configured MS SQL Server 2008 R2 built-in log shipping from primary server to standby server
• Configured database mirroring as a high availability solution with the primary, mirrored and witness servers.
• Configured database mirroring in high safety and high performance modes depending on the requirement.
• Creation and maintenance of Databases, creating Roles and managing user permissions, resolving blocks and deadlocks.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification and indexing updates.
• SQL Development- experience in creating database architecture with associated schema as part of a software design process.
• Work with IT and business teams to determine and define database maintenance windows.
• Implement best practices for Database Monitoring, Backups and Restores.
• Work with Data Center teams on the infrastructure, network and storage issues.
• Provide off hour support during peak business activity period and during application deployments.
• Expertise in SQL server technologies for Clustering, non-clustering, High Availability and Disaster Recovery

Environment: SQL Server 2008, database mirroring, log shipping, SSRS, Query Analyzer, and Performance Tuning.

Confidential, Morristown, NJ

SQL Server DBA

Responsibilities:

• Setup Replication (both Transactional and Merge replication) for multiple point of presence for business data.
• Configured Transactional Replication (Creating Distribution Databases, updating Publishers, creating & managing Publications, managing Replication monitors).
• Configured Merge replication for the particular applications.
• Set up jobs and Database maintenance plans for backups, index rebuilding and statistics update.
• Performed backups and restores on servers as needed or for a company process.
• Installed and maintained SSRS on our Enterprise SQL server 2005 environment.
• Prepared new documentation and maintained updates on existing documentation.
• Transformed packages from one server to the other in SQL 2000/2005 using SSIS.
• Used performance Monitor, Profiler, Activity Monitor to troubleshoot Dead Locks Long running queries.
• Provided 24 x7 supports for production and monitored issues proactively before client complaints.
• Optimization of T-SQL procedures using SQL Server tools.

Environment: SQL Server 2005, transactional replication, merge replication, SSRS, SSIS, Query Analyzer, and Performance Tuning.

Confidential

Jr.SQL Server DBA

Responsibilities:

• Created User defined roles on SQL Server 2005 to meet certain security concerns.
• Created User access, SQL Logins, Roles and Schemas for different database objects
• Created Jobs and scheduled them for database backup and to run scripts.
• Configured, deployed and monitored SSIS Packages.
• Configured and maintained Report Manager and Report Server for SSRS.
• Configured and maintained Microsoft SQL Server 2005 fail over clustered environment.
• Followed the checklist to install sql server 2005 and managed it.
• Implemented and monitored Replication to make data available at different locations.
• Acknowledged SQL Server Alerts in the environment and resolving.
• Monitoring and resolving the alerts from SQL Server boxes in Production Environments.
• Problem analysis/making proposals for alternative solutions.
• Performed SQL Server tuning to improve performance.
• Coordinated with different teams during production releases
• Recommended next generation database enhancement
• Provided 24 x7 supports for production and monitored issues proactively before client complaints.

Environment: SQL Server 2005, T-SQL, SQL Server Integration Services, SQL Server Reporting Services.