SUMMARY:

• Managing Very Large Database (VLDB) arrays and DBA teams
• Configuring and optimizing SQL Servers and SQL Server database performance and capacity planning
• Performance Tuning, Troubleshooting, Index and Query Optimization using Database Console Commands (DBCC) and Dynamic Management Views (DMVs), supporting developers in coding for optimal database performance
• Data modeling (Logical and Physical database design)
• T - SQL programming, Stored Procedures and Triggers
• SQL Server database security strategies
• SQL Server Integration Service (SSIS) and Data Transformation Service (DTS) package development
• Software Development Life Cycle
• Project Management including Risk, Quality, and Change Management.

TECHNICAL SKILLS:

Operating Systems: Windows Server 2012/2008/2003, MS-DOS, UNIX, Linux

Database Systems: SQL Server 2016/2014/2012/2008/2005/2000/7, Oracle 12c/11g/10g, Sybase 16.x/15.x/12.x

Programming Languages: Visual Basic, FoxPro, T-SQL, PL/SQL, COBOL, dBase, Pascal

Development tools: Visual Studio, FrontPage, HTML, ASP, VBScript, ADO, OLAP, Erwin, Visio

Analysis/Methodology: Agile, Waterfall, Cost/Benefit Analysis, Gap Analysis, Feasibility Analysis

Reporting tools: Crystal Reports, Data Report Designer, SSRS

Applications: MS Office, MS Project, QuickBooks Pro, Serena Dimension CM.

PROFESSIONAL EXPERIENCE:

Confidential, Lanham, MD

Lead SQL Server Database Administrator

Responsibilities:

• Managing over 120 SQL Server databases in Production environment including VLDB very large database of 1.6 Terabyte in size, and Azure (Cloud) platform supporting the Department of Housing and Urban Development (HUD)
• Leading, managing and mentoring SQL Server DBA team; identifying and recommend training opportunities for Junior and Mid-level SQL Server DBAs
• Providing support to Sybase/Oracle DBAs as necessary
• Planning and implementing MS SQL Server software installations, upgrades, service packs and patches
• Developing and continually testing disaster-recovery plans for large client operational databases
• Ensuring consistency in database development by coordinating with development teams to define database code standards and naming conventions
• Conducting root cause analysis and implementing permanent fixes for database-related issues, resolving performance issues (e.g. deadlocks, CPU, I/O, and Memory) using measurement tools such as SQL Profiler, Perfmon, DMVs, and Tuning Advisor
• Proactively monitoring Production database health with various DBCC and DMV statements
• Managing 24/7 on-call DBA support team for Production database Servers, overseeing daily team activities e.g. checking SQL Server logs, Windows event logs, SQL Server Agent Jobs, disk space
• Designing and implementing High Availability/Disaster Recovery SQL Server solutions, including Always On Availability Group (AAG), Mirroring, Log shipping, Replication, and Clustering
• Managing data migration and ETL processes e.g. migrated SharePoint Content Databases to SQL Server Database Azure, using DTS and SSIS to import/export data from various data sources e.g. Flat file, CSV file, ODBC/OLEDB to SQL Servers
• Managing upgrades on multiple Development, Test, and Production Servers
• Implementing and monitoring security audit controls to track unauthorized database access and violations
• Creating physical databases from logical designs, and also database objects including tables, views, triggers and stored procedures
• Implementing change control management to track production database configuration and objects changes

Confidential, Falls Church, VA

SQL Server Database Administrator

Responsibilities:

• Performed day-to-day DBA duties e.g. creating and managing user accounts, assigning permissions and roles, scheduling jobs, backups, database replication and performance tuning, database backup/restore and disaster recovery procedures
• Provided query writing and query tuning assistance to developers
• Performed index usage analysis, updated the database with optimal indexes, scheduled re-indexing and defrag to run off hours
• Created database objects including tables, views, triggers, constraints and stored procedures
• Setup Log Shipping from OLTP Servers to Standby Servers to provide High Availability
• Proactively monitored system and server resource usage to identify potential performance problems
• Created database maintenance plans and schedules jobs, Alerts, and SQL-Mail notifications
• Developed DTS packages for data Extraction, Transformation and Loading

Confidential,

Greenbelt, MD

System Administrator

Responsibilities:

• Acted as escalation point for troubleshooting network/systems issues, consistently awarded 100% issue-resolution scores
• Created physical databases from database designs, created database maintenance plans and scheduled jobs
• Trained employees across multiple departments on network operations, COTS applications usage

Confidential

Systems Analyst/ Programmer

Responsibilities:

• Designed, developed and implemented the following Applications ( Personnel Information System, Financial Analysis SW, with Visual Basic, Quality Control SW with MS Access, Stock Management SW, Fixed Asset Management SW with dBase IV
• Maintained and modified existing software systems to address changing business needs
• Provided technical support services to internal customers, planned and delivered computer training for employees.