SUMMARY:

• Nine (9) years of experience in Database Administration, system analysis and administration, design, development and support of MS SQL Server 2016/2008/2005 , 2000 and 7.0 in production and development with log shipping, mirroring, replication and clustering environments
• Experience managing very large database SQL environments
• Strong DBA experience in 24/7 call center environments and production environments with a thorough understanding of Standard Operation Procedures (SOP) and Service Level Agreements (SLA)
• Implemented and worked on Change Data Capture (CDC)
• Experience working with OLTP/OLAP environments that include production (24 x 7), QA and development databases in SQL Server
• Experience in MS SQL Server installation, configuration, performance tuning, client/server connectivity, query optimization, back - up/recovery and ran DBCC commands
• Experience importing and exporting data from Excel and Oracle that was sent to the MS SQL Server databases using DTS and SSIS utilities
• Experience in data migration from SQL Server and and 7.0 to 2000
• Intensive experience in performance tuning and monitoring SQL Server and database performance using Database Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows performance monitor
• Proficient in automating processes by creating jobs and error reporting using alerts and SQL mail agent
• Skilled in designing and implementing different types of replication models, database mirroring modes and clustering environments (active/passive) to further increase the scalability and the stability of business-critical systems
• Performed ETL operations to support the data loads and transformations using SSIS (SQL Server Integration Services)
• Strong in SQL, T-SQL and PL/SQL database programming, development of Stored Procedures, Cursors, Triggers and Views
• Performed regular application builds and test builds using TFS
• Supported and worked with Epic Clarity ETL tools for huge reporting applications
• Thorough knowledge of SAN and RAID technologies
• Installed and Maintained SQL Server in Virtual VMware and Hyper-V system environments
• Managed multiple offshore projects and teams

SKILL:

Languages: T: SQL, PL/SQL, VB, C, C++, XML

RDBMS: MS SQL Server 2016/2012/2008 R 2/2005/2000/7.0 , MS Access 2005/2000, Sybase ASE

Web Tools: MS Front Page, Internet Information Server (IIS), FTP, TCP/IP, LDAP, SMTP, LAN, and MS Outlook Express

Database: Windows 2012, 2008R2, 2003, 2000 Enterprise Server, Windows NT 5.0/4.0/3.5, Windows 9.x/3.x, MS DOS SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), Database Engine Tuning Advisor, Data Transformation Services, DTSRUN, MS Visio, SQL Loader and import and export (DTS), SQL Profiler, Performance ManagerQuery Analyzer, Data Migration Assistant, SSIS, Erwin, Quest Lite Speed, Crystal Reports 10.0, Cognos Reporting, Toad, Veritas Net backup, Red-Gate, SQL CMD

Tools: MS Office, MS Project, Visual Source Safe 6.0, Windows Active Directory, System Center Operations Manager (SCOM), Informatica, Benchmark testing, Power Designer, MS Visio, BizTalk, MOM (Microsoft Operations Manager)

EXPERIENCE:

Sr. SQL Server DBA

Confidential, Raleigh, NC

Responsibilities:

• Maintaining SQL Server 2016, 2012 & 2008 Production Servers,
• Migrating SQL Server and SQL Servers,
• Migrating SQL Servers to AWS and PostgreSQL And Managing PostgreSQL Databases,
• Maintaining Prod, Test and Dev Environments and taking care of Ad hoc requests
• Maintaining Databases on AWS Environment
• Taking care of SSIS Packages and SSRS Reporting features across all environments
• Installed and maintaining SQL Servers in Virtual VMware system environment
• Provided 24x7 production database support using SQL alerts
• Performance tuning complex queries based on the issues
• Using T-SQL Stored Procedures, Functions and Triggers whenever required for ongoing development requirements, SSIS Packages and SSRS Reporting
• Working closely with other developers, project management, and key stakeholders
• Assisting with development standards based on industry accepted methodologies and standards
• Designing new schemas and databases according to the new business and application requirements

Environment: Windows 2016/2012/2008 R2, MS SQL Server 2016/2008R2, SQL Server Data Tools, SQL Server Migration Assistant, BIDS (SSIS & SSRS), FTP, SQL Profiler, database Engine Tuning Advisor, T-SQL, MS Office

SQL Server DBA/Migration Lead

Confidential, Raleigh, NC

Responsibilities:

• Installed SQL Server 2016/2017 on a Windows 2012 Server environment and migrated the existing SQL Server 2008/2005 databases to SQL Server 2016
• Maintained data security using encryption/decryption in SQL Server
• Installed and maintained SQL Servers in Virtual VMware system environment
• Maintained SQL Server databases on AWS
• Secured the SQL Server using transparent data encryption
• Provided 24x7 production database support using SQL alerts
• Performance tuned complex queries based on the issues
• Used T-SQL Stored Procedures, Functions and Triggers whenever required for ongoing development requirements, SSIS Packages and SSRS Reporting
• Worked closely with other developers, project management, and key stakeholders
• Assisted with the establishment of, and adherence to development standards based on industry accepted methodologies and standards
• Designed new schemas and databases according to the new business and application requirements
• Completed the regular database builds and deployments on test and production database environments
• Designed and implemented database backup and restoration strategies
• Implemented and maintained database maintenance plans as per the project and business environment
• Developed, deployed and maintained reports using SQL Server Reporting Services (SSRS)
• Fixed the daily production server, database and data issues
• Updated T-SQL codes and Stored Procedures as per the requirements
• Worked on the database physical and logical modeling
• Worked on SQL Server Integration Services (SSIS) as per the business requirements
• Documented all the design changes and modifications to the systems

Environment: Windows 2016/2012/2008 R2, MS SQL Server 2016/2008R2/2008/2005, SQL Server Data Tools, SQL Server Migration Assistant, BIDS (SSIS & SSRS), FTP, Terminal Server, SQL Profiler, database Engine Tuning Advisor, DTS, T-SQL, MS Visio, MS Office

Sr. SQL Server DBA

Confidential, Raleigh, NC

Responsibilities:

• Installed SQL Server 2012 in a Windows 2008 server environment and migrated the existing SQL Server 2008/2005 databases to SQL Server 2012
• Maintained the data security using encryption/decryption on SQL Server
• Installed and maintained SQL Servers in Virtual VMware system environment
• Secured the SQL Server using transparent data encryption
• Provided 24x7 production database support using SQL alerts
• Performance tuned complex queries based on the issues
• Developed, deployed and maintained reports using SQL Server Reporting Services (SSRS)
• Created Ad hock data reports on daily basis depending on requirements & needs
• Worked closely with other developers, project management, and key stakeholders
• Participated as a key team member in a .NET & Java software development effort
• Assisted with the establishment of, and adherence to, development standards based on industry accepted methodologies and standards
• Designed new schemas and databases according to the new business and application requirements
• Completed the regular database builds and deployments on test and production database environments
• Designed and implemented database backup and restoration strategies
• Implemented and maintained database maintenance plans as per the project and business environment
• Fixed the daily production server, database and data issues
• Updated the T-SQL codes and Stored Procedures as per the requirements
• Worked on the database physical and logical modeling
• Worked on SQL Server Integration Services (SSIS) as per the business requirements
• Documented all the design changes and modifications to the systems

Environment: Windows 2016/2012/2008 R2/2008/2005, MS SQL Server 2016/2012/2008 R2/2008/2005, SQL Server Data Tools, BIDS (SSIS & SSRS), MS Access 2003, FTP, Terminal Server, SQL Profiler, database Engine Tuning Advisor, DTS, T-SQL, MS Visio, MS Office