SUMMARY:

• Expertise in SQL Server Database Administration, Management, Upgrading, Migrations and Development in Production\Nonproduction environment and clustered environments.
• Proficient in Database Backup, Recovery and Disaster Recovery Procedures.
• Proficient in configuring Database High Availability techniques like Database Mirroring, Log Shipping, AlwaysOn Availability groups, Clustering and Replication on SQL Server 2005, 2008, 2008R2, 2012, 2014 and 2016.
• Proficient in implementing diverse types of Replication Models such as Transactional, Snapshot and Merge in SQL Server.
• Knowledge in Power shell scripting to automate DBA tasks.
• Experience with Database Performance Tuning, Query Optimization, Client / Connectivity / Network Issues, Named Pipes, TCP/IP Protocols, Troubleshooting, Database consistency checks using DBCC Utilities.
• Experience in logical and physical designing of Relational Databases based on System Development Life Cycle (SDLC).
• Proficient in using Performance Monitor, SQL Profiler and Database Tuning Advisor to solve Dead Locks and long running queries.
• Expertise in investigating and applying necessary SQL Server database patches and installing service packs.
• Experience with third party tools like Idera, Ignite, Spotlight and SCOM for monitoring performance.
• Expertise in configuration and management of Linked Servers for data transfer between SQL Server and other.
• Involved in optimizing code and improving efficiency in databases including updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Possess a good working knowledge of the responsibilities as an Application front end DBA. Jobs involved stripping of tables across multiple disks & partitions, tuning SQL queries.
• Proficient in maintaining and resolving issues in SQL Server Clustering and worked on Active - Active Clustering.
• Expertise in project management-taking a project through its life cycle on a timely basis within its budget.

TECHNICAL SKILLS:

Database: MS SQL 2016, 2014, 2012, 2008, 2005 MS Access

Software: C, Cobol, Interactive SQL, T-SQL, PL/SQL, Wired, MRC, and Pascal

Operating Systems: MS 2000, 2003, 2010, 2012

Monitoring Tools: Idera, Ignite, Spotlight

Backup & Restore: LiteSpeed

PROFESSIONAL EXPERIENCE:

Senior SQL Database Admin (Consultant)

Confidential

Responsibilities:

• Successfully configured HA concept AlwaysOn Availability groups on SQL Server 2012 for Mission critical applications.
• Installed and configured SQL Server 2012, 2014 and 2016 Enterprise Edition Environment.
• Technical Support of MS SQL Server 2008R2, 2012, 2014 and 2016 Servers Platform for Production, Test and Development Environments (Clustered/non-clustered).
• Patching of Sql Server Instances and coordination of Windows OS patching on Sql Servers with AlwaysOn.
• Support deployment, migration and implementation on production SQL server environments.
• Perform Backup and Restore operations during off-hours for the Development team.
• On call production support for Microsoft SQL Servers and databases.
• Recommend Performance Tuning, Query Optimization and Query Execution plan analysis to Application Developers on SQL server databases.
• Support multiple SQL Instances on Cluster environment for Server Consolidation projects.

Senior SQL Database Administrator

Confidential, NY

Responsibilities:

• Installed and configured SQL Server 2012, 2014 and 2016 Enterprise Edition Environment.
• Technical Support of MS SQL Server 2008R2, 2012, 2014 and 2016 Servers Platform for Production, Test and Development Environments (Clustered/non-clustered).
• Successfully configured HA concept Sql Server AlwaysOn Availability groups on SQL Server 2012 for Mission critical applications.
• Perform Backup and Restore operations during off-hours for the Development team.
• Support multiple SQL Instances on Cluster environment for Server Consolidation projects.
• Monitor and ensure that scheduled jobs are running and completed for business cycle on Microsoft SQL Servers in Production, UAT, QA and Dev. Environment.
• Utilize DELL Spotlight to monitor SQL server instances to resolve and improve production and performance issues.
• On call production support for Microsoft SQL Servers and databases.
• Support deployment, migration and implementation on production SQL server environments.
• Refresh Non-Production environment through backup and restore using LiteSpeed.
• Troubleshoot space issues like transaction log full, data file full, clearing the drive space.
• Troubleshoot deadlock and blocking issues.
• Patching of Sql server instances and coordination of Windows OS patching on Sql Servers with AlwaysOn.

Senior Database Administrator

Confidential, West Trenton, NJ

Responsibilities:

• Installed and configured SQL Server 2005, 2008 R2 and 2012 Enterprise Edition Environment.
• Upgraded SQL Server 2005, 2008 to SQL 2012.
• Technical Support of MS SQL Server 2008 and 2012 Servers Platform for Production, Test and Development Environments (Clustered/non-clustered).
• Implement Database Mirroring and Logshipping for Disaster Recovery.
• Performed SQL server RDBMS installation, upgrade, configuration, backup, recovery, archiving & purging.
• Successfully configured HA concept AlwaysOn Availability groups on SQL Server 2012 for Mission critical applications.
• Perform Backup and Restore operations during off-hours for the Development team.
• Support multiple SQL Instances on Cluster environment for Server Consolidation projects.
• Work with developers/team for the achievement of efficient database access for applications. Work scope includes designing, adding, eliminating or maintaining indexes, organizing tables, recommending SQL changes to application development teams.
• Monitor and ensure that scheduled jobs are running and completed for business cycle on Microsoft SQL Servers in Production, UAT, QA and Dev. Environment.
• Utilize DELL Spotlight, Idera and Ignite to monitor SQL server instances to resolve and improve production and performance issues.
• Set up Transactional and snapshot Replication for Production Environment.
• Set up of production snapshots with PowerShell script through IBM Tivoli Management Services.
• Transform data from various data sources like MS Access, MS Excel using OLE DB connection by creating various DTS packages.
• On call production support for Microsoft SQL Servers and databases.
• Support deployment, migration and implementation on production SQL server environments.
• Recommend Performance Tuning, Query Optimization and Query Execution plan analysis to Application Developers on SQL server databases.
• Refresh Non-Production environment through backup and restore using LiteSpeed.
• Troubleshoot space issues like transaction log full, data file full, clearing the drive space.
• Troubleshoot deadlock and blocking issues.
• Analysis of database growth and recommendations for additional capacity (hardware, memory etc.)

Database Administrator

Confidential, Jersey City, NJ

Responsibilities:

• Responsible for the installation, management and maintenance of SQL Server 7.0, 2000, and 2005 Databases.
• Configured and tested scripts, stored procedures, database security, capacity planning, replication, Data Mirror, Log Shipping, triggers, and query optimization.
• Created a working environment for Application Developers on a test database and tune the Server Database for speedy data access to clients.
• Analyzed existing database and design the best viable way to implement in the Client/Server Environment.
• Provided Oracle and SQL Database support.

SQL Server DBA

Confidential, NJ

Responsibilities:

• Responsible for the installation, management and maintenance of SQL Server 7.0 and 2000 Databases.
• Analyze existing database and design the best feasible way to implement in the Client/Server Environment.
• Configure and test scripts, stored procedures, database security, capacity planning, replication, triggers, and query optimization.
• Create a working environment for Application Developers on a test database and tune the Server Database for speedy data access to clients.
• Use ERwin to create database models, schemas, relationship integrity, stored procedures, Triggers, and indexes for our projects.
• Study Analysis report and advise programmers on the appropriate procedures, packages, triggers and function calls to use in development of the code.
• Manage database backup and restores, and disaster recovery plans.

SQL Server DBA / Point of Sale Systems Manager

Confidential, NJ

Responsibilities:

• Managed and maintained all SQL Server 7.0 and 2000 Databases for Point of Sale Systems and Applications.
• Installed, configured and maintained 2000 and 7.0 databases.
• Designed, managed and tracked projects throughout the project’s life cycle.
• Managed and coordinated projects team resources.
• Tuned MS SQL Server 7.0 and 2000 databases performance.
• Indexed tables and file structures.
• Used T-SQL to code stored procedures and triggers.
• Coordinated with business partners in defining project scope and requirement.
• Created and managed projects timelines and project deliverables to ensure on time and on budget completion.
• Conducted status meetings to communicate projects status and performance issues.

SQL DBA

Confidential, NY

Responsibilities:

• Maintained and managed MS SQL 7.0 and 2000 Databases.
• Installed and configured 7.0 and 2000 databases.
• Provided support and advised programmers regarding SQL implementations.
• Designed Data modeling solutions with ERwin to drive business goals of personalized content.
• Configured and tested scripts, stored procedures, database security, capacity planning, replication, triggers, and query optimization for templates.
• Interfaced with hosting facility and Primedia assets to ensure backup schedules are adhered to.
• Maintained production, staging and development databases.

SQL DBA

Confidential, NY

Responsibilities:

• Maintained ownership of GEAC Financials (General Ledger) underlined with MS SQL 7.0 database.
• Performed thorough and aggressive testing of GEAC related modifications test environment prior to implementation on Production Server.
• Installed patches and upgrades on GEAC application and SQL Servers.
• Provided performance tuning and monitoring of MS SQL Server 7.0 databases.
• Created data model and star schema using ERwin.
• Worked with Users to validate the functionality of their data and reports.
• Granted users access to the database and reset their passwords.
• Created, monitored, and tuned SQL 6.5 and 7.0 server databases for optimum performance.
• Acted as Project Manager for Supplier Report System, which was converted from Lotus/FoxPro to a new Supplier Report System in Crystal Reports, Visual Basic and MS SQL 7.0 database with Web base user interface.

Project Leader / SQL DBA

Confidential, NJ

Responsibilities:

• Created and administered our Direct Market Electronic Commerce Order Processing Web Database, this was an MS SQL Server 7.0 Transactional Replication used between our server and an off-site server.
• Used ERwin 3.5.2 to create database models, schemas, relationship integrity, stored procedures, Triggers, and indexes for our projects.
• Consults with end users to assist them in setting up database schemas, accessing warehouse database or data marts, troubleshooting, and create database rights, views, and indexes.
• Established the proper change control environment for supporting multiple instances and versions of application software and develops scripts to automate routine database administration tasks.
• Developed databases for Corporate Image System, Retail Image System and Image Catalog for our Intranet applications.
• Maintain and monitor the RDMS environment to minimize downtime and increase optimum performance
• Created, configured, monitored, and tuned SQL 6.5 and 7.0 server databases for optimum performance.
• Part of the Y2K team responsible for ensuring all applications and software are Y2K compliant, as well as the remediation of all libraries on our MIPS system.
• Responsible for conversion of Paradox reports for our Merchandise Group to Microsoft Access Database, Production Download in REXX Routine with Client Access to NetSoft Manage Transfer on Window NT Workstation.
• Develop the Production Download in SQL 7.0 database.
• Gathered users’ business needs and defined systems requirements and assisted in the initial design of systems
• Investigated, recommended and implemented new decision support tools.
• Assisted in the location and distribution of AS/400 information requested.
• Managed hardware & Software support vendors.
• Managed departmental PC and Software rollout.
• Provided product training and support.