SUMMARY:

• Practical database architecture, design, and development under Microsoft SQL Server platforms.
• Functional and technical experience in full systems development life cycle (SDLC), quality management, performance improvement, process reengineering, change management and production support.
• Experience in agile methodology using best practices from SCRUM.
• Proven ability to work efficiently as in small and large software developments environment.
• Consistently demonstrated proficiency at quickly learning and contribution to business operations and system improvement in both internal and client facing consulting roles.
• Excellent in interpersonal communication, problem solving, documentation and business analytical skills.

TECHNICAL SKILLS:

Operating Systems: Windows NT/2000/XP/ 2003/2008/7/8/2010, VMware

Hardware: SAN, RAID

Databases: MS SQL Server, MySQL

Data Modeling: ER - Win, SQL Server Database Diagram

Languages: Transact SQL (T-SQL), PL/SQL, C++, HTML, XML

Reporting Tools: SQL Server Reporting Service, TIBCO Spotfire, Adhoc Editor, Crystal reports

ETL Tools: SSIS/DTS, WhereScape Red

SQL Server Tools: SSMS, SQL Profiler, Query Analyzer, Red Gate SQL Compare

Performance Monitor Tool: Fog light, SQL Sentry, PerfMon, Execution plan, Activity Monitor, DMV

PROFESSIONAL EXPERIENCE:

Confidential, Jacksonville, FL

SQL Server DBA

Responsibilities:

• Administer and maintain SQL server 2008 R2, 2012 and 2014. Supporting over 60 SQL servers running 2500 databases.
• Install, configure, upgrade and apply patches to SQL server stand alone and clustered instances. Work with SAN storage, Active Directory and System Admin team to configure storage\Windows server for optimal performance to SQL server standard and to ensure prerequisites are met for new server build.
• Configured log shipping as the disaster recovery solution and transitional replication to achieve scalability of databases and improve read performance. Also involved in building shared infrastructure with clustering to provide High Availability which helped consolidate 8 servers and saving licensing cost.
• Ola Hallengren maintenance scripts modification: Update statistics only when needed. This project cut the update statistics process by 99% in time and resources (from 5hrs to 5 min nightly).
• Minimized backup-restore time, disk I/O and storage space by implementing RedGate backup compression. Which also speeded up network file transfer and secured the backup with 256-bit AES encryption.
• Monitor database log files, data block corruption, segment fragmentation, contention issues (deadlocks, I/O, memory, CPU, etc.) and performance issues via Foglight.
• Optimized T-SQL query performance using SQL profiler, execution plans and DMV’s. For instance, implemented procedure to update statistics on demand for financial calculations. Decreased execution time from 15 min to 2 min.
• Responsible for setting up security and providing user access to SQL server instance and objects.
• Implemented a third party ETL tool called WhereScape RED that is used to build IDW (Internal Data warehouse).
• Developed several stored procedures to generate complex financial reports using TIBCO Spotfire and Adhoc Tool (.Net based In-house software that uses SSRS).
• Review and deploy code to lower environments and production (SDLC). Provide feedback related to code performance to developers\application teams before production releases. Promote code changes to Development, QA and Production Server using SVN\GIT.

Confidential, New York City, NY

Jr SQL DBA/Developer

Responsibilities:

• Installed, Configured, and Managed SQL Server 2000, 2005 in development, test, and production environment.
• Managed Backup/Restore, Point-in-Time Recovery including backup verification, security.
• Install, Configure and Maintain Fail-Over Clustering using SQL Server 2005.
• Install and Configure SQL Server Reporting Services (SSRS).
• Upgrade databases from SQL Server 7.0/2000 to 2005 in testing and production environment.
• Data Modeling, developing E-R Diagram using Erwin and SQL Server Data Diagram.
• Export & Import data from Flat file, CSV file, Oracle, My-SQL, and Access to/from SQL Server Database using DTS, SSIS.
• Schedule jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification.
• Monitor Server Activity, Error Log, space usage, and solving problem as needed.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using Business object and SSRS.
• Created views to facilitate easy user interface implementation, and triggers to enforce Data and referential integrity.

Confidential, New York City, NYC

SQL Server Developer

Responsibilities:

• Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Worked on DTS Package, DTS Import/Export for transferring data between SQL Servers.
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Used DDL and DML to writing triggers, stored procedure to check the data entry and payment verification.
• Worked closely on database tuning, performance planning, backup planning and database administration.
• Take participation in migration from SQL server 2000 to SQL server 2005.
• Generating ad-hoc reports using MS-Access and Crystal Reports.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.
• Data Transfers between various servers using BCP and Managing Disk space on NT systems.