We provide IT Staff Augmentation Services!

Sr. Database Administrator\lead Dba Resume

Princeton, NJ

SUMMARY

  • Microsoft certified SQL Server DBA with 17 years of experience in database administration, monitoring, designing, troubleshooting and performance tuning, seeking for a challenging position with a prospective and growing company to utilize and expand my technical knowledge, skills and expertise using SQL Server Database 2016/2012/2008 R 2/2005/2000.
  • My expertise entails in database optimization, installation, backup/recovery, DR/HA, database design, security management including data encryption/decryption, ETL, SSIS and SSRS. Ability to identify root causes, bottlenecks and other database issues to troubleshoot and resolve promptly.
  • Skilled in high availability SQL Server solutions including Log Shipping, Mirroring, Replications, Always On Availability Groups and SQL Server Clustering. I am an effective communicator with strong work ethic, exceptional relationship, management skills and ability to relate to people at any professional level.
  • Installation and configuration of SQL server 2016/2012/2008 /2005/2000.
  • 24/7 on call support in Production, Testing and Development environment.
  • Good understanding and working knowledge of SQL Azure.
  • Migrated and Created SQL Server Databases using PaaS and IaaS.
  • Automated Patching for SQL Server in Azure Virtual Machines (Resource Manager)
  • Implemented, Configured, and Supported H/A technologies with Azure SQL Server.
  • Good understanding of VmWare 5.5. Concepts and Implemented in Data centers.
  • Experience with database Backups and Restores.
  • Good experience in applying SQL Server Service Packs in all SQL 2016/2012/2008 servers.
  • Performed Log Shipping and Database Mirroring as disaster recovery solution to different customers.
  • Implemented Active Passive Clustering as high availability techniques using Always on in all SQL 2016/2012 servers.
  • Installation and configuration of MS SQL Server Reporting Services (SSRS).
  • Expert in performance tuning and handling blocking situation and dead lock situations.
  • Experience in Deploying SSIS Packages in various environments.
  • Experience in Performance Tuning, Query Optimization, Database consistency checks using DBCC utilities and Index Tuning Wizard.
  • Experience in maintaining the security for databases (creating logins for users, roles, and assigning permissions to them).
  • Experience in working with Windows Server 2012/2008/2003 Enterprise Editions, Windows 2000 Advanced Server, Windows 2000 Server and Windows NT.
  • Excellent communication and interpersonal skills, self - motivated, quick learner and determination to learn new technologies, strong troubleshooting skill and good Team player with excellent interpersonal and team work skills.
  • Good team player with strong analytical skills.

TECHNICAL SKILLS

Operating Systems: Windows Server 2012/2008/2003/2000 ,Windows 98/XP/Professional

Database Tools: Profiler, DTS, Management Studio/Enterprise Manager, Query Analyzer, SSIS, SSRS.

Performance tools: Spotlight.

Web Server: Internet Information Server 6.0 /7.0

Databases: SQL Server 2016/2012/2008 /2005/2000, MS Access, Oracle 7.3, DB2

Reporting Tools: SQL Server Reporting Services, Crystal Reports

Backup Tools: VERITAS, Lite speed, DDBoost.

Cloud: VmWare 5.5, Azure SQL

PROFESSIONAL EXPERIENCE

Confidential, Princeton, NJ

Sr. Database Administrator\Lead DBA

Responsibilities:

  • Managing all SQL Servers in all environments i.e. SQL 2016/2012/2008 .
  • Migrated and Created SQL Server Databases using PaaS and IaaS.
  • Automated Patching for SQL Server in Azure Virtual Machines (Resource Manager).
  • Implemented, Configured, and Supported of H/A technologies with Azure SQL Server
  • Installation and Configurations of Large SQL Database instances.
  • Performance tuning of large databases at Application, Operating systems and Database Levels.
  • Backup and restore of SQL Server databases using Lite Speed and Veritas and DDbost in SQL2016\2012 environments.
  • SQL Server 2012 and 2016 Migrations (Side By Side Migration).
  • Implementing High Availability features like Always On in SQL2016\2012 environments.
  • Extensive use of Data mirroring to replicate the data from PROD to DR
  • Deployed SSIS packages and SSRS Reports.
  • Monitored, Automated and scheduled jobs through SQL Server Agent.
  • Coordinating with the I.T. Manager and Business Stakeholders, system downtimes and deployment of latest database releases across all environments. (Dev, UAT, Prod)
  • Provided back-up DBA support for all DBA team members.
  • Involved in setting up a Datacenter for Community Health Network of Connecticut.
  • Implemented Active \Active and Active\passive Windows clustering.

Confidential, Princeton, NJ

Sr. Database Administrator

Responsibilities:

  • Creating Database Backups and Restores upon client requests.
  • Creating and managing user roles and assigning necessary permissions.
  • Creating automation of maintenance jobs, Day-to-day maintenance activities such as running DBCC, Transaction Logs, File growths etc.
  • Implement all high availability techniques like log shipping, Database Mirroring
  • Solve critical production issues, such as table deadlocks and blocking
  • SQL Servers 2008 Migrations.
  • Coordinating with the I.T. Manager and Business Stakeholders, system downtimes and deployment of latest database releases across all environments. (Dev, UAT, Prod)

Confidential

Sr.Database Administrator/Tech. Lead

Responsibilities:

  • Installed CRM Application and Web Vehicle Applications on Remote Servers
  • Managed a team of 8 members.
  • Installation and configuration of SQL server 2008/2005 with respective service packs.
  • Maintained SQL Server Databases approx. 200 databases.
  • Using TSQL Scripts automated maintenance activities.
  • Migrated data from MS SQL Server 2000 to SQL Server 2005 and SQL Server 2008
  • Monitored, Automated and scheduled jobs through SQL Server Agent.
  • Maintained Database authentication and authorization of database objects, created users, configured permissions and assigned roles to users.
  • Used Performance Monitor, SQL Profiler and Database Tuning Advisor to solve Dead Locks / long running queries / Indexing.
  • Continuously Monitored routine data maintenance like re-indexing, database shrinking, and log file monitoring using Dynamic Management Views and Functions.
  • Responsible for Database Backups & Restoration, Backup Strategies and Scheduling Backups.
  • Involved in Running DBCC consistency checks, and fixing data corruption in user databases.
  • Monitored database growth activities & Troubleshoot Transaction Log & Space Issues
  • Investigated and applied necessary SQL Server database patches and installed service packs.
  • Involved in performance tuning and building indexes for query optimization.
  • Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
  • Created SSIS Tasks and assigned to MS SQL Server Agent.
  • Deployed SSIS package for bulk insert and maintained archival data.
  • Monitored the event logs and Server error logs for troubleshooting purposes.
  • Created web sites in IIS to access CRM Application (Web Servers).
  • Created FTP sites for installing Web Vehicle Applications.
  • Installed Crystal reports application viewer and hotfixes.
  • Provided back-up DBA support for all DBA team members.
  • Installed .NetFramework2.0 and MSxml4.0 and Crystal Reports Viewer.
  • Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).

Hire Now