SUMMARY

• Certified SQL Server DBA with over eight (8+) years of experience in IT and database administration, development and technical support.
• Detail oriented, analytical and troubleshooting experience in different Microsoft products like SQL Server, reporting services, data modeling and Operating systems, Windows Clustering. Solid knowledge and experience in managing medium to large scale databases in 24/7 environments including backup/recovery, monitoring and Performance tuning, security, high availability, implementing Disaster recovery plan, developing and managing reports using SQL Server reporting services (SSRS), SSIS packages, stored procedures, triggers, functions, constraints and views etc.

TECHNICAL SKILLS

• SQL Server
• Windows Server
• IIS
• Symantec NetBackup
• TDP (Tivoli)
• SiteScope
• Litespeed
• Power shell
• MS Visio
• SAN
• Exchange server2010/2013
• Remedy7.5 and 8.1
• ServiceNow
• ITIL v3
• ITIM System
• MS Business Intelligence
• Share Point
• Oracle 10g &11g
• Linux/Unix.

PROFESSIONAL EXPERIENCE

Confidential, Alexandria, VA

SQL DBA

Responsibilities:

• Providing database administration and support on production, test and development environments of MS SQL server 2016, 2014, 2012, 2008R2, 2008, 2005 and 2000 on windows server 2012 and 2008, 2003.
• Install Configure and Manage SQL Server 2016, 2014, 2012 and 2008R2 and patching, applying Service Packs and Hot Fixes.
• Create an integrated maintenance plans, i.e. automated jobs like backup, shrink database, update statistics, rebuild index, reorganize Index, maintenance cleanup, history cleanup and notify operator tasks and execute SQL server agent jobs.
• Support and Maintain Fail - Over Cluster Servers, maintain individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
• Performance tuning using SQL Server profiler, Database tuning advisor, Windows performance monitor, Query Analyzer and fine tuning long running queries and stored procedures and slow running server.
• High Availability: ensured SQL Server replication and mirrored database are operating as planned.
• Configuring, enabling and monitoring Always on feature, Replication, Mirroring and Failover clustering for SQL server databases across servers.
• Perform statistics management, managed SQL Server Error Logs, space usage and growth pattern. Manage the unexpected growth transaction log files (LDF) of database
• Used DBCC Commands to manage database consistency, index fragmentation and statistics.
• Security Management: Created and managed users, roles, security at object level, monitored user accounts, creation of groups and granting privileges to users.
• Database Migration from SQL Server 2000/2005 databases into MS SQL Server 2008 R2, 2012, 2014 and 2016. Using backup/restore, import/export wizard, SSIS techniques from different data centers, from Physical to Virtual servers.
• Backup/Recovery: Developed and applied storage strategies and disaster-recovery plan for large operational database that guaranteed recovery performance and high availability.
• Have good knowledge and managing on Virtualand Physical servers.
• SSIS: Design, develop and deploy ETL solutions in SSIS and created SQL Server Agent jobs.
• Reports: Installed, Configured and administered SQL Server Reporting Services (SSRS). Developed Reports using SSRS. Deployed multi-valued parameterized reports including matrixes, charts, and gauges in SSRS.

Environment: SQL Server 2016/2014/2012/2008 R2/2008/2005, Windows Server 2012/2008/2003 , IIS, Symantec NetBackup, TDP (Tivoli), SiteScope, Litespeed, Power shell, MS Visio, SAN, Exchange server2010/2013, Remedy7.5 and 8.1 (Incident and change management), ServiceNow, ITIL v3, ITIM System, MS Business Intelligence Development Studio 2012/2008/R2/2005, Share Point, Oracle 10g &11g, Linux/Unix.

Confidential, Alexandria, VA

SQL DBA

Responsibilities:

• Involving in Installation, Configuration of SQL Server 2008 R2, 2008 & 2005 in development, test, and production servers. Applied Service Packs and Hot fixes (patches) to keep the SQL server at current patch level.
• Monitoring SQL Server Error Log, space usage, Events, Jobs, customer complaints.
• Scheduling jobs to automate different database related activities including backups, Rebuilding indexes at regular intervals, reorganize Index, maintenance cleanup, history cleanup and notify operator tasks for better performance and other Maintenance plans.
• Creating tables, views, Indexes (Clustered and Non-Clustered), Constraints (Unique, check, default).
• Manage and monitor the performance of SQL server by using SQL Server tools like SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor and by running the DMV and DBCC commands.
• Upgrading databases from SQL Server 2000 to 2005/2008 and SQL Server 2005 to 2008/2008 R2.
• Backed up databases to different Medias (Local Drive, Network Derive, File server, Tape) and restoring databases from backups including point-in-time Recovery.
• Installing, configuring and maintaining database mirroring with automatic fail-over, Log shipping from production database for Reporting purpose, Replications (Transactional).
• Administering SQL Server Reporting Services (SSRS). Develop, deploy and manage Reports using SSRS and Ad-hoc reports using Report builder 3.0/2.0.
• Export & Import data from multiple sources and destinations.
• Extracting, transforming and loading (ETL) data from different data sources and loading to the appropriate format. Creating SSIS package and deploying the package.
• Assist database developers to optimize SQL Queries, Stored Procedures, and triggers.

Environment: SQL Server 2008R2/2008/2005, Windows Server2008/2003, IIS, SpotLite, LiteSpeed, Idera, Red Gate, MS Visio, SAN, Microsoft SQL ServerVisual Studio 2008/2005, MS Business Intelligence Development Studio 2008

Confidential, Washington, DC

SQL DBA \Developer

Responsibilities:

• Installed, Configured, and Managed SQL Server 2008, 2005, & 2000 in development, test, and production environment.
• Involved in data modeling project and design the model using ERWin tool.
• Used DBCC to check database conditions, Rebuilding indexes and other database Maintenance purposes as well. Scheduling Jobs and Alerting using SQL Server Agent.
• Monitored performance using SQL Server profiler, Windows performance monitor and Database engine tuning advisor analyzed and fine-tuned long running queries, stored procedures and slow running servers.
• Created documentation for installation, monitoring procedures, security policies, configuration changes, migration procedures, and best practices.
• Login and User Management: Adding logins, roles, groups to the Windows server 2003/2000 and MS SQL Server and maintaining proper security procedures.
• Backup and Restore of mission critical databases and system databases.
• Created and configured database mirroring and log shipping, replication database for high availability and disaster recovery purpose.
• Wrote and executed Upgrade scripts for making changes to the production server.
• Worked with developers to tune up SQL/T-SQL queries, wrote stored procedures, triggers and functions.
• Developed SSIS packages to ETL (extract, transform and load) into the database from source database.
• Performed in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP
• Installed, configured and maintained SQL Server 2008/2005 Reporting Service. Managed reports and worked with developers in designing and developing reports.

Environment: Windows Server 2003, MS SQL Server2005/2000, Windows SCOM, SAN, T-SQL, Visual Studio, Crystal Reports 8.5, IIS, Lite Speed, MS Access, DTS, BCP, SSIS, SSAS, SSRS, SQL Server Profiler.