We provide IT Staff Augmentation Services!

Senior Sql Database Admin Resume

NY

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.

Hire Now