SUMMARY:

• SQL Server DBA with extensive experience in database design, development, performance tuning, back up/recovery troubleshooting and the support and maintenance of SQL Server and other RDBMS.
• Hands On experience in Database administration, server and database security architecture.

TECHNICAL SKILLS:

OS: Windows 2000/2003/2008 R2/2012R2, Windows NT, UNIX (Sun Solaris 2.7), shell script, Windows Professional, Windows 98

DB: MS SQL Server 6.5/ 7.0/2000/2005 /2008/2008 R 2/2012/2014/2016, MYSQL 5.0, 5.5, Sybase 10.0/11.0/11.5/11.9/12.5 ASE, AWS,Enterprise Edition; Oracle 7. X/8i/9i/10g, MS Access Datawarehouse, OLAP

Tools: SQL, TSQL, SSIS, SSAS, Powershell, PL/SQL, Oracle SQL*Plus, SQL Server Enterprise Manager; SQL Query Analyzer, SQL Profiler, DTS, Informatica, DTS, BCP, SQL Loader,IDERA SQLDM, SQLCM, SQLSafe,TOAD, SQL Navigator for SQL Server, DB - Artisan, Erwin 3.5,4.0, REMEDY, Hummingbird DM5/DOCSOPEN, HL7, EMR, Database ENCRYPTION, TDE.

Compare;: Crystal Reports Version 5.0, 6.0, 7.0; Client/Server; IBM/Lotus Approach

Web: IIS 4.0/5.0, MS Visual Studio, MS Visual Interdev 6.0, MS Proxy Server 2.0

PROFESSIONAL EXPERIENCE:

Confidential, Washington DC

Sr. SQL Server DBA

• Had a team of 7 people working under my direct supervision.
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Involved in logical and physical design of data warehouse.
• Experience in creating complex SSIS packages using proper control and data flow elements. Work included the population of staging database as a prestep to populate the data warehouse.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Wrote SQL scripts for creating daily backups of OLAP databases. Created scheduled jobs to monitor the database and data warehouse backup jobs, monitor the disk space.
• Have successfully performed disaster recovery mockup drills each year during the project to simulate recovery of all our production SQL Server installations in an event of disaster.
• Supported all production operation activities, with focus on integration and development of new and existing products and services.
• Migrated Databases from Sybase to SQL Server 2000. Mission critical 24/7 production applications were hosted on SQL Server Enterprise edition, Windows Advanced Server 2003. Active/Passive Cluster Server configuration.

  Hardware: HP DL 780 4 Xeon Processors 2.8 GHz HT, HP DL380.

  Software: SQL Server 7.0/2000/2005, Erwin 4.0, SQL Server Enterprise Manager, SQL Server profiler, SQL Query Analyzer, Sybase11.5/12.5ASE, Windows NT 4.0/2000. Hummingbird DOCS OPEN/DM5, REMEDY

Confidential, Sterling, VA

Federal Integrator

Responsibilities:

• Create how-to guideline and scripts documents to address database updates involving replicated tables that already exists
• Designed and build the database tables and relationships
• Designed and implemented transactional and merge replications
• Troubleshoot the replication issues.
• Addressing database related requests from developers regarding installation of servers, user access and privileges and permission issues in the current environment
• Setting up SQL Trace to troubleshoot bottleneck issues. Testing and deployment
• Documenting change control requests and attend ccb meetings to get approval to implement changes into production.
• Update DB documentation/EA Model
• Create database optimization routines that address replication related latency issues nut not limited to it.
• Developed Analysis Services Project. Responsible for identifying and defining Data Source and Data Source views. Created cubes and defined the dimensions.
• Defining relationships between Dimensions and Measure groups.
• Creating BACKUP strategy for SQL databases using new features SQL 2008

Software: SQL Server 2008/2008R2 Cluster Enterprise, SSIS, SSAS, Powershell,Windows Server 2008 Enterprise edition, Windows MSCS Clustered Environment, VMware, Enterprise Architect 7.5.8, JIRA, SQL Server Profiler.

Confidential, Arlington, VA

SQL Server DBA

• Involved in redesigning effort of the existing database application, which include effort to normalize the database tables, identification of entity relationships, defining the relationships and creating a mechanism to enforce the relationship. Using CA Erwin tool to create ERD.
• Optimizing queries for better performance, using SQL Server profiler, Windows performance monitor and SQL query execution plans
• Installation of replication server, configuration and monitoring the replication between two sites, implemented Transactional replication. Implemented replication (transactional and snapshot) between Main production server and reporting server. Creating and running SSIS packages to transform and move data between servers.

Software: Red Gate SQL data compare, CA Erwin, SQL Server profiler, Windows performance monitor, SSIS.

Confidential, Washington D.C

SQL Server DBA

• Planning and Implementation of migration from SQL Server 2000 to SQL Server 2005.
• Analysis and Design of disaster recovery and high availability..
• Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS ETL packages.
• Have expert understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Have configured and deployed SSIS packages on servers.
• Extensive experience in creating stored procedures, triggers and cursors.
• Implemented SQL Server Security baselines recommended by Microsoft and SQL Server security best practices and guidelines by DISA for SQL Server 2000 and SQL Server 2005.
• Created SQL Auditing, and enabled SQL Auditing on SQL Server.
• Created customized Database Audit specifications.
• Installing and Configuring of SQL Server 2005 Database in clustered environment, Database Mirroring & Log Shipping for high availability solutions.
• Implementation of system wide security policies and trouble shooting.
• Remote Installing, Configuring and monitoring of SQL Server 2005 Database using Windows Batch Scripts, Command Line Interface.
• Installed and configured SQL Server 2008 on development servers. Involved in setting performance benchmark for SQL Server 2008 which will host production applications in future.
• Analysis of Tables, Stored Procedures, Views, Defaults, Triggers, Indexes and suggested corrective measures
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification, indexing and shrinking of databases and daily monitoring of SQL Server databases.
• Monitored the performance using sql profiler and windows performance monitor tool.
• Worked on the security administration, created roles for various application groups.
• Administered the Windows 2003 server like ADS and applied security patches, hot fixes etc.

Software: Windows Server 2003 64 Bit enterprise edition, Two node Active-Passive Clustered SQL Server, SQL Server 2005/2008 Enterprise 64 bit, SQL Server 2000 Enterprise