Resume

Sign in

SQL Database Administrator/Data Mideler

Location:
Arlington County, Virginia, United States
Posted:
November 24, 2018

Contact this candidate

Resume:

``PROFESSIONAL SUMMARY:

US citizen with about six (6) years of professional hands-on experience as a MS SQL Server Database-Administrator (DBA) working on SQL Server Database Administration, Database Design/Modelling, Report Development (SSRS), Report Deployment, Report Distribution, DTS, Data Migration Using SSMA from Oracle, MySQL, MS Access Database, ETL, Integration Services (SSIS) Packaging, managing Very Large Databases (VLDB), Backup/Recovery, Monitoring, Troubleshooting, Performance Tuning, Replications, AlwaysOn, Mirroring, Clustering, AlwaysOn and writing SQL/T-SQL scripts - Stored Procedures, Functions, Triggers, Constraints, and Views. I have in-depth knowledge and experience with Database Security, Encryption, TDE (Transparent Data Encryption), and third party tools like RedGate, Idera, Solarwinds, OpNet, Spotlight, ERWin, Toad Data Modeller and Toad for SQL Server Admin.

I have communication/social skills and ability to manage multiple complex projects having innovated and a creative problem solver, results oriented. Experienced with Software Development Life Cycle (SDLC) such as requirement gathering & analysis, design, development, testing, implementation, & maintenance.

Besides that I also hold hands on experiencing Operating Systems (Windows 2012R2, 2008 R2, and 2003 R2).

Self-motivated, team player with excellent verbal, written, and communication skills with business analysis and technical knowledge.

TECHNICAL SKILLS:

Databases: SQL Server 2016, 2014, 2012, 2008R2, 2005, and MS Access.

SQL Server Tools: SQL Server Management Studio (SSMS), Enterprise Manager, Business Intelligence Development Studio (BIDS), Query Analyzer, SQL Profiler, Database Tuning Advisor, Index Tuning Wizard, BCP, SQLCMD, Upgrade Advisor, SQL Configuration Manager, Client and Server Network Utilities, and Surface Area Configuration.

Database Tools: Profiler, DTS, Activity Monitor, Management Studio/Enterprise Manager, Query Analyzer, SSIS, and SSRS.

Reports Development/Management: Report Development, deploy, manage, migrate, and upgrade reports and Report Server. Strong expertise on configuring and managing Report Server such as SQL Server Reporting Service (SSRS), developing report using BIDS (Business Intelligence Development Studio), SSDT (SQL Server Data Tools), and Report Builder, using Microsoft Access and Microsoft Excel to map with SQL Server for data manipulation and Data Analysis.

Data Modelling: ERWin, SSDD (SQL Server Database Diagram).

Programming: SQL, T-SQL, scripting, debugging, and improved performance stored procedures, Functions, and Triggers.

SSIS/DTS: DTS, SSIS Package create, manage, deploy, upgrade and migrate packages.

Data Migration: Using SSMA for DB2, SSMA for Oracle, and SSMA for MySQL and SSMS Export/Import tool.

Performance Tuning: Server Optimization and Performance Tuning, Query Optimization, Experience in resolving Dead Locks or long running queries. Experienced in using different Tools - Profiler, Execution Plan, Performance Monitor, Activity Moni Extended event, Database Tuning Advisor, DMV, Windows Performance Monitor, and Idera SQL Diagnostic.

Database High Availability: Strong knowledge/experience in configuring and administering High Availability Database Solutions like Database Mirroring, AlwaysOn, Replication, Log shipping, and Cluster Database.

Windows Server and Active Directory: Experience in administering Windows Server 2012R2, 2012, 2008 R2, 2003 R2, AD (Active Directory), Domain, DNS, File server, Monitoring user activities, and VMware.

Security: Experience with Security and Audit Management like Security, Encryption, TDE (Transparent Data Encryption), AES, and 3DES.

Upgrade/Migrate: Migrated Oracle, MySQL, Sybase to SQL Server and Upgraded databases from MS SQL Server 2005, 2008 R2, 2012 to higher version.

Application Server: Administered IIS application server, and deployed applications.

Service Pack: Applied Service Pack (SP) and Hot Fixes for Standalone, Clustering, AlwaysOn Instances, and Operating Systems.

Third Party Tools: Idera, Erwin, and Toad for SQL Server Admin.

SQL Scripting/Web Technologies: SQL, T-SQL, HTML, VBScript, ASP, .Net Technologies: VB. NET, and ASP.NET.

Dot Net Technologies: .Net Technologies: VB. NET, and ASP.NET.

Development Tools: Visual Studio (VB), Visual Studio2010/2012, 2015, 2017, BIDS, and SSDT.

Operating System: Excellent Knowledge in Windows Server 2008 R2, 2012 and 2012R2, add Role and Features, Creating Domain Controller, Creating Cluster, User, Group and Grant Permission and maintain security through Windows level.

VMWare/Virtual Box: Knowledge and experience of Installing, and working on VMWare/ Virtual box.

Azure SQL: Create databases, Create Storage and container, Migration data to Using Data-tier Application Export and Import (BACPAC), by Generating a Script, DMA, create Azure VM machine, and Azure SQL Data Sync.

PROFESSIONAL EXPERIENCE:

Feb 2015 to Present Department of Health and Human Services, MD

SQL Server DBA/Data Modeler

Responsibilities:

Managing Development, Test and Production Servers/Instances and Databases.

Database Migration:

oUpgraded SQL Server 2005, 2008 /2008 R2 Databases into SQL Server 2012, 2014, and 2016.

oApplied Service Pack (SP) and Hot Fixes.

oMigrated MySQL and Oracle Databases into SQL Server 2012 and 2014.

oMigration SQL Server Databases from physical and VM to Azure SQL Database in Azure Cloud Environment.

Database Administration:

oInstalled, Configured, and Administered SQL Server as standalone, side-by-side, and in-place.

oAdministration includes SQL Server 2008, 2008 R2, 2012, 2014, and 2016.

Database High Availability:

oInstalled, Configured, and Managing Database AlwaysOn, Mirroring, Replication and Log Shipping.

oInstalled, Configured and Maintaining Fail-Over Cluster Servers in SQL Server 2008, 2008 R2, 2012 & 2014.

SQL/T-SQL, Triggers, Stored Procedure:

oWrote SQL, T-SQL, Stored-Procedures and Triggers.

oOptimized SQL queries, Stored Procedures and Functions.

Monitoring and Performance Tuning:

oPerformance Tuning, Query optimization, identifying and troubleshooting I/O, memory bottle necks, lock, block and deadlocks, monitoring sessions, and query executing.

oCreating Jobs for database maintenance Index fragmentation, rebuild indexes and database statistics, and check and manage database consistency.

oUsed DBCC and ALTER statements to check and manage database consistency, index fragmentation/reorganizing/rebuilding, and statistics.

oMonitor and resolve deadlock for client issues. Troubleshooting connectivity issues, Permissions etc.

oMonitoring SQL server performance using profiler to find performance.

oPerform Database tuning and capacity planning to ensure acceptable level of performance.

oSystem performance monitoring by I/O, processes wait-time, response time, physical memory, network bandwidth with traffic, connection conjunction, and space availability.

oMemory allocation, data portioning, adding devices, and moving data for better performance.

oMonitoring, Troubleshooting Instances, Databases, and Queries using different tools.

oQuery Execution plans, Profiler, Database Tuning Advisor, PerfMon /Task manager, Activity Monitor, Server Logs, Agent Logs and Error Logs, Event Logs, DMV (Dynamic Management View), Maintain Indexes, and Statistics Management.

Database Automation:

oCreated Backup jobs for different types of backups like FULL, Differential and Transaction Log.

oCreated Jobs for database maintenance Index fragmentation, reorganizing/ rebuild, and database statistics.

Data Modelling:

oWorked on different Data Modelling projects including ERWin Modeller on designing Logical & Physical Database.

Index/Constraints, Triggers, Stored Procedure:

oCreated and managed Index (Cluster/Non-Cluster), and Constraints.

Security Management:

oCreated and Managed users, roles, security at object level, data encryption, TDE and Dynamic data masking.

Backup/Recovery:

oWork experience and strong knowledge in disaster recovery.

oRestore and Recover databases using backups.

Reports:

oInstalled, Configured, and administered SQL Server Reporting Services (SSRS.)

oDeveloped Reports using SSRS.

oDeveloped Ad-hoc Reports using Report Builder.

oDeployed Reports and managed security for reports.

Work Environment: Azure SQL, SQL Server 2016, 2014, 2012, 2008 R2, Windows Server 2012R2, 20112, 2008 R2, AD (Active Directory), Financial Applications, Enterprise Reporting System, IIS, Dot Net.

Aug 2012 to Dec 2015 Department of Labour, Washington DC

MS SQL Database Admin/Database Architect

Responsibilities:

Database Programming: Wrote T-SQL, Trigger, and Stored-Procedures. Assisted Database Developers to optimize SQL queries and Stored Procedures.

ETL Tools: Used ETL tools like DTS, SSIS, Import/Export, BCP (Bulk Copy), to import & export data from flat files, and excel to MS SQL Server databases.

Export & Import: Data from/to Oracle, MySQL, and Access Database including flat files like text, Excel, and CSV files to SQL Server 2005/2008r2 and 2012.

Report Development: Installed, Configured, and administered SQL Server Reporting Services. Developed Reports using SSRS. Deployed Reports. Developed Ad-hoc Reports using Report Builder 3.0, 2.0.

Used DBCC to check database conditions, and Rebuilding indexes and other database Maintenance purposes as well.

Database High Availability: Installed, Configured and Maintained Fail-Over Clustering using SQL Server2012, 2008R2, 2005. Installed, and configured and Maintained Database Mirroring using automatic fail-over option in SQL Server 2008R2. Configured Log Shipping as Standby database from Production database for Reporting purposes. Configured and Maintained Replications.

Database Upgraded: SQL Server 2005 to SQL Server 2008 R2, 2008 R2 to 2012.

Database Migration: Migrated MS Access 2003 & 2000 databases into MS SQL Server. Migrated Oracle, and MySQL into MS SQL Server 2008R2.

Data Modelling: Worked on more than 10 data modelling projects and generated E-R Diagram. Data modelling tool using SQL Server Data Diagram.

Database Monitoring/Performance Tuning: 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, and space usage.

Backup/Recovery: Strong knowledge and working experience in Database Backup and Disaster Recovery. Experienced with Point-in-Time Recovery. Restored Database from backup.

Work Environment: SQL Server 2012, 2008 R2, Windows Server 2012R2, 2008 R2, AD (Active Directory), and Applications in .Net Platform.

EDUCATION & CERTIFICATIONS:

BSc in Computer Information Systems

CERTIFICATIONS:

Microsoft Certified IT Professional (MCITP-Database Administrator) – SQL Server 2012/14

SECURITY CLEARANCE: Clearable

References: Available Upon Request



Contact this candidate