SUMMARY:

• An experienced Certified Microsoft SQL Server Database Administrator/BI Developer with SQL/TSQL skills having more than 6 years, who is dedicated to keep up - to-date industry knowledge looking for SQL Server Database Administrator/DBA job. Dedicated and responsive professional has experience in managing production, test/UAT, development environment, requiring minimum or no supervision and be productive from the first day of the job. Professional experience entails configuring, and managing Databases and Database Servers using SQL Server 2016/2014/2012/2008 R2/2005/2000 and Operating System Windows Server 2012, 2008 R2, 2003 R2 including Virtual and Azure Environment.
• Extensive experience in SQL Server Database Management System in the areas of Database Administration, Reporting, Data Modeling, Database Design and Development, Advanced Installation, Configuration, Backup and Recovery, Upgrade, Service Pack (SP), SQL/T-SQL, Stored Procedure, Trigger, DMV, DBCC,Clustering, Always On, Log Shipping, Mirroring and Replication.
• Proven experience in Database Performance Tuning using SQL Server Profiler, Extended event, Database Engine Tuning Advisor, Execution plan, Performance Monitor and other third party tools like RedGate, OpNet and SolarWinds.
• Configured and managed High Availability and Disaster Recovery solutions like Log shipping, Mirroring, Replication, SQL Server clustering and AlwaysOn.
• Experience in creating, supporting and maintaining database administration scripts.
• Expertise in working on multiple data modeling projects including gathering, analysis, conceptual, Logical and Physical data modeling using tools ERWin, Toad Data Modeler, SSDD.
• Experienced with SQL/T-SQL scripts including scripts/SQL/TSQL for managing Database and database objects.
• SSIS & DTS Packages: Created, configured, deployed, and managed including Migrate and Upgrade.
• Highly proficient in Installed, Configured, and administered SQL Server Reporting Services (SSRS), created, deployed, managed reports including migrating reports.
• Experienced in Data Movement, data dumping using different tools like Export & Import utility, Data Tools, BIDS, SSIS, and DTS including Excel File, Flat file, CSV file, SQL Server Database.
• Upgraded and migrated from SQL Server databases and instances from older version to newer version like SQL 2005 to SQL Server 2008 R2/2012 in different environments.
• Good knowledge and working experience in Operating Systems (O/S) - Windows Server 2008 R2, Windows Server 2012 R2.
• Securing SQL Servers and Databases, Manage users, Data encryption, granting/ revoking access.
• Extensive work experience in Compression, Database maintenance and Optimization.
• Excellent ability to work as part of a team and independently and able to manage time too effectively to meet deadlines and prioritize workload.
• Performed on call support duties as well including other maintenance related support.
• Effective communication, multi-tasking and prioritizing skills, excellent interpersonal skills, strong customer focus, quick learner, reliable and dependable.

TECHNICAL SKILLS:

Cloud/Azure: experience entails Azure Services, migrated on premises databases and Legacy databases to Azure, deployed products on Azure, and setup development and test environment on Azure.

Database Management: Strong knowledge and working experiences as Database Administrator of MS SQL Server (2005, 2008 R2, 2012, 2014, 2016)., Working Experience SQL Server 2014 in Test Environment, Strong work experience and knowledge in SQL Server Replication, Log shipping, Mirroring, Clustering, Performance tuning, Backup/recovery, Query Optimization, Database and Column Level Encryption, and Security Management, Maintain Management Plan, Job Set up and monitor job activities.

Programming and Testing: SQL, T-SQL, Functions, Store Procedures, Trigger.

Data Modeling: Backward Engineering, Forward Engineering.

Database: Can Create Conceptual, Logical, and Physical Data Model.

Tools: used: ERWin, Toad Data Modeler, and SQL Server Database Diagrams, Good Understanding about Data Warehousing, Schema, OLAP.

Reporting Service: SQL Server Reporting Services (SSRS), visual Studio - Installation, Configuration, and Management,Developed, Deployed, and Managed Reports.

Integration Service: SQL Server Integration Services (SSIS), DTS, BCP - Installation, Configuration, and Management, Developed and Deployed SSIS packages.

Operating Systems: Worked on Operating Systems like Windows Server 2003 R2, 2008 R2 and Windows Server 2012 including installation, and configurations.

Virtualization: Installed, Configured, and Managed SQL Server in virtual environment using VMware and VSphere.

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Database Administrator

Responsibilities:

• Cloud/Azure: Migrated on premises databases and Legacy databases to Azure, and setup production, development and test environment on Azure.
• Managed Database Servers in Development, Test, and Production environment.
• Installed, Configured, and Managed SQL Server 2008 R2, 2012, 2014, 2016 in Development, Test, and Production environment.
• Installed, Configure and Maintained HA/DR Solutions using Clustering, AlwaysOn, Mirroring, Replication, and Log Shipping.
• Installed, Configured monitored and troubleshoots Log Shipping as Standby database from Production database for Reporting purposes.
• Installed, Configured, and administered SQL Server Reporting Services (SSRS).
• Developed and deployed different type of repot using different data source like SQL Server, Oracle, CSV, and Excel.
• Delivered reports to users in variety of format like Report Server (Web Based), Excel, CSV, PDF formats.
• Upgraded/Migrated SQL Server 2005 to SQL Server 2012/2008 R2.
• Migrated MS Access Database 2000, 2003 into SQL Server 2008 R2, 2012.
• Migrated Oracle 10gR2/11gR2 and My SQL 5.1.23 Database to SQL Server 2008 R2/2012.
• Good understanding on data modeling projects and generated E-R Diagram.
• Data Modeling tools used: Toad Data Modeler, SQL Server Data Diagram.
• Backward & Forward Engineering with data modeling tools mentioned above.
• Applied SP/ Hot Fixes (Service Pack) on SQL Server.
• Applied SP/Hot Fixes on SQL server Instances to address Security and upgraded related issues.
• Strong on database Monitoring and Performance tuning.
• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, and backup verification.
• Monitor SQL Server Error Log, Space usage.
• Strong on SQL Server Profiler, Extended Events, Database Engine Tuning Advisor, Performance Monitor, Activity Monitor, Execution plan.
• Besides Native tool, used OpNet as a Third Party Tool for monitoring and Performance Tuning.
• Writing T-SQL, Functions, Trigger, Partition, View, and Stored-Procedures, joins, union and writing scripts for job set-up.
• Assisted Database Developers to optimize SQL queries and Stored Procedures.
• Export & Import data from Excel File, Flat file, CSV file to/from SQL Server Database using BIDS, SSDT.
• Export & Import data from/to databases as My-SQL, and Access to/from SQL Server.
• Creating SSIS Packages and deployed from different sources like SQL Server Database, Flat file, CSV, Excel and many other data sources supports OLEDB Data sources.
• Setup jobs from SSIS Packages.
• Data analysis and migration by transferring and using SSIS packages.
• Skilled in creating simple, parameterized and complex reports involving Sub Reports, Matrix/Tabular Reports.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports and drill down reports using SSRS.
• Developed a Tabular Reports, ad-hoc reports using SSRS Report.
• Experience with logical and physical data modeling and database design using Erwin.
• Package Configuration, SSRS, SSAS and Data-warehousing.
• Experience in Designing and Building dimensions and cubes using SQL Server Analysis Services
• Created report snapshots to improve the performance of SSRS.
• Improved the accuracy of the source data by implementing data validation on the source Data for reporting
• Created subscriptions in SSRS to deliver reports to a shared file.
• Implemented logical and physical modeling using ERWIN data modeler
• Strong knowledge and working experience in Database Backup and Disaster Recovery.
• Experienced with Point-in-Time Recovery.
• Restored Database from backups.

Environment: Microsoft Cloud/Azure, SQL Server 2008 R2, 2012, 2014, 2016 IIS 7.5, 8.5, Windows Server 2008 R2, 2012 R2, ASP, ASP.net, Java, ETL and AD (Active Directory).

Confidential, Washington, DC

SQL Server Database Administrator

Responsibilities:

• Installed, Configured, and Managed SQL Server 2008 R2, and 2012 in development, test, and production environment.
• Installed, Configured database associated tools and performance monitoring Software.
• Setup, Configured, monitors and Maintained Database Replications.
• Installed, configured, maintain and monitored troubleshoots SQL Server Database Mirroring.
• Configured and Maintained Log Shipping as Standby database for Reporting Purposes.
• Securing SQL Servers and Databases, Manage users, Data encryption, granting/ revoking access.
• Data Encryption and Data Decryption for data security in Database & Column level.
• Managed Backup/Restore, Point-in-Time Recovery including backup verification, security by native tools and RedGate tools.
• Applied SP (Service Pack) on SQL Server 2008R2 and 2012
• Expertise in database Performance tuning SQL profiler, Execution Plan, Database tuning Advisor, Activity Monitor, Performance Monitor.
• Monitored data activities such as logs, space utilization, locks, long transaction.
• T-SQL, Stored-Procedures, Triggers, Function, Views, Indexes.
• Developed and maintained scripts, utility jobs or implement needed software for database maintained.
• Created and managed Indexes, Constraints, and Keys (Primary Key, Foreign Key).
• Worked on different Data Modeling projects including creating scripts, E-R Diagram, backward/forward engineering
• Worked multiple Data Modeling projects for different applications
• Processed data dump and Exported & Imported data from Flat file, CSV file, Oracle, My-SQL, and Access to/from SQL Server Database using DTS, SSIS, and EXP/IMP tool.
• Export & Import data from Flat file (CSV, Excel) to SQL Server Database using EXP/Imp and DTS tool.
• Installed and Configured SQL Server Reporting Services (SSRS).
• Developed and Managed Report in SSRS (SQL Server Reporting Services) including managing securities
• Setup automated jobs for different purposes including backup, monitoring database health, disk space, backup verification and moving databases from environment to environment including creating test environment.
• Developed different maintenance plans such as backups, index management, fragmentation management, cleaning history, deleting old files.
• Monitored Server Activity, Error Log, space usage, and solving problem as needed.
• Executed change management scripts on weekly basis.

Environment: SQL Server 2008 R2, 2012 IIS Server 6.5, 7.5, Windows Server 2008 R2, 2012 R2, ASP.net, Java, ETL and AD (Active Directory)