SUMMARY:

Microsoft Certified Professional (MCP) SQL Server Database Administrator with 7 years of experiences in planning, installation, configuration and administration of MS SQL Server 2016/2014/2012/2008 R2/2005 in development, testing and production environment. Expertise in SQL server security management, SQL Server performance tuning, troubleshooting, Migration/Upgrading, Disaster Recovery and High availability Solutions. Proficient with use of Stored Procedures, views, functions, triggers, DBCC, and joins. Experienced on developing and deploying reports using SSRS. Performed Extracting, Transforming, and, Loading data (ETL) using SSIS. Hands on experience on developing and deploying SSIS projects and packages. Excellent ability to work in fast - paced and demanding environment with great problem solving and analytical skills.

TECHNICAL SKILLS:

Database (RDBMS): SQL Server 2016/2014/2012/2008 R2/2005

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

High availability: Log shipping, Replication, Mirroring, SQL clustering, Always on availability

Performance Monitoring Tool: Profiler, DMV, Activity Monitor, Execution Plan, PerfMon, Extended Event, Database Tuning Advisor

Reports Development/Management: SSRS, MS Access, Excel

ETL Tools: DTS(Visual Studio), SSIS

Operating System: Microsoft Windows Server 2012, 2008, 2008 R2/2003/R2, Windows XP/vista/Win7, 8, 10

Third Party Tools: Red Gate, Erwin, Toad Data Modeler, SharePoint; Net Backup.

PROFESSIONAL EXPERIENCE:

SQL DBA

Confidential, MIAMI, FL

Responsibilities:

• Installed and Configured SQL Server 2016/2014/2012 in standalone, and clustered nodes
• Applied service packs, hotfixes and cumulative updates
• Created and maintained logins, Users, Roles and managed security of the database.
• Implemented the principle of least privilege to ensure the security of data and objects in SQL server
• 24 X 7 Production database support on call
• Performed Full, Differential and Transactional log backups and setting automated jobs.
• Migrated data using Import/Export, bulk, backup-restore, DTS, SSIS, Detach/Attach
• Developed an action plans for Migrating data from one environment to an other
• Migrated data, users, login, objects, and jobs from Development environment to the Production environment
• Assisted developers during database design and creation.
• Worked Using SSIS to ensure the ETL process of records.
• Imported raw data from outside source by using ETL process.
• Created SSIS projects, and packages
• Deployed SSIS projects and Packages to production server and outside destinations.
• Automated SSIS package deployment using SQL Server Agent
• Involved in Rebuilding /Reorganizing indexes to reduce fragmentation and enhance SQL server performance
• Created triggers, views and stored procedures,
• Optimized stored procedures and complex queerize to increased their performance
• Implemented database Maintenance plans, scheduled automated SQL Server jobs, Created Alerts, Operators, Notifications and configured database Mail.
• Hands on experience monitoring and performance tuning using Tuning Advisor, SQL server Profiler, Activity monitor, Windows performance monitor, DBCC, DMVs
• Troubleshooting to find out performance issues in SQL Server
• Working with Resource Governor to control and allocate CPU and memory resources depending on the priority of applications.
• Configured and Managed Database High Availability: Replication, Database Mirroring, Log Shipping, Failover Clustering and Always On availability group.
• Scheduled reports using SSRS to generate daily, weekly, monthly, quarterly reports
• Conducted various meetings and conferences with clients to meet corporate milestones for database consolidation and data migration.
• Worked in team with both integrated Developers, CAB (Change Approval Board) and Disaster Recovery Planning team.
• Experience in Agile projects with a solid foundation in Software Development Lifecycle (SDLC).

Confidential, Washington DC

SQL DBA

Responsibilities:

• Installed and Configured SQL Server 2016/2014/2012/2008 R2 and 2008 in standalone, and clustered nodes
• Applied service packs, hotfixes and cumulative updates
• Upgraded SQL Server 2005, 2008 and 2008 R2 Database into SQL Server 2012 and 2014
• Created and maintained logins, Users, Roles and managed security of the database.
• 24 X 7 Production database support on call
• Implemented Disaster recovery plan by performing routine backups and restore
• Performed Full, Differential and Transactional log backups and setting automated jobs.
• Migrated data using Import/Export, bulk, backup-restore, DTS, SSIS, Detach/Attach
• Performed data Extracting, Transforming and Loading (ETL) from data sources.
• Involved in Rebuilding /Reorganizing indexes to reduce fragmentation and enhance SQL server performance
• Created triggers, views and stored procedures,
• Implemented database Maintenance plans, scheduled automated SQL Server jobs, Created Alerts, Operators, Notifications and configured database Mail.
• Hands on experience monitoring and performance tuning using Tuning Advisor, SQL server Profiler, Activity monitor, Windows performance monitor, DBCC, DMVs, Stored procedures
• Working with Resource Governor to control and allocate CPU and memory resources depending on the priority of applications.
• Configured and Managed Database High Availability: Replication, Database Mirroring, Log Shipping, Failover Clustering and Always On availability group.
• Scheduled reports using SSRS to generate daily, weekly, monthly, quarterly reports
• Conducted various meetings and conferences with clients to meet corporate milestones for database consolidation and data migration.
• Worked in team with both integrated Developers, CAB (Change Approval Board) and Disaster Recovery Planning team.
• Experience in Waterfall as well as Agile projects with a solid foundation in Software Development Lifecycle (SDLC).

Confidential, Baltimore, MD

SQL DBA

Responsibilities:

• Involved in Planning, Defining and Designing database using conceptual, logical and physical models based on business requirements and provided documentation.
• Provided database administration and support on production and development SQL server 2008 and 2012
• Created and maintained various logins, assigned appropriate database roles and privileges to users based on the required access
• Developed and performed SQL server post installation maintenance plans: Database backup, integrity check, update database statistics, and index maintenance using GUI and T-SQL
• Migrated data using Import/Export, bulk and batch processing, backup-restore, DTS, SSIS, Import/Export.
• Monitored performance of SQL Server 2005/2008 and 2012 databases
• Expertise in Database Tuning, indexing Tables, and optimizing statistics
• Installed, authored, and managed reports using SQL Server 2008/2012 Reporting Services
• Hands-on experience on indexes creation:-clustered and non-clustered, managing index fragmentation
• Identified and troubleshoot storage bottlenecks CPU, Memory, I/O, Disk space, and other resource contentions.
• Created scripts and various database objects as needed
• Applied DAC (Dedicated Admin Connection) when the normal connection fails to connect
• Maintained the database Integrity by using DBCC at regular intervals.
• Created demographic and Comparative Reports using SSRS

Confidential, Alexandria, VA

Junior Data Analyst

Responsibilities:

• Installed, Configured, and Managed SQL Server 2005, 2008 engine and reporting services in development, test, and production environment.
• Migrated MS SQL Servers 2008R2 to 2012 and performed upgrade and service packs
• Managed Server security including implementation of Logins, Roles, Authentication Modes, and SQL Server Audits for various users.
• Responsible for creating, modifying and managing tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers
• Scheduled database maintenance tasks to improve the database performance.
• Analyzed and optimized T-SQL queries using execution plans and created indexes.
• Performed Database Backup, Restore and Point-in-Time Recovery.
• Migrated and tested DTS packages, Export & Import data from Flat file, CSV file, MySQL, and Access to/from SQL Server Database using DTS, SSIS. .
• Involved in rebuilding/reorganizing indexes at regular intervals for better performance.
• Configured and supported SQL server Log Shipping, Database Mirroring, Transactional and Snapshot Replication.
• Monitored Server Activity, Error Log, space usage, and solving problem as needed
• Experienced with DBCC commands, to check physical and logical consistency of the databases.