We provide IT Staff Augmentation Services!

Sql Dba Resume

0/5 (Submit Your Rating)

SUMMARY

  • 7+ years of experience with MS SQL Database administration, including expertise in Performance turning.
  • Strong background in Backup's/Restores, Performance Tuning and Issue resolution.
  • Experience in Installing, configuring, upgrading, monitoring, maintaining and managing multiple SQL Server databases.
  • Independently installed SQL servers 2008 R2, SQL 2012 and 2014 servers.
  • Proactively managed the database infra. And ensured that they are always available and stable.
  • Demonstrated experience in multitasking between more than one application
  • Strong knowledge of Microsoft Windows
  • Accurate and thorough
  • Excellent problem solving, interpersonal and communication skills
  • Excellent in written, oral and presentation skills.
  • Experienced in Change, release and incident management methodologies.
  • Graduate of Computer science and Engineering.
  • Computer skills include: - MS SQL Server, Ticketing tools like HPSM and Service now, Spotlight, Windows server 2003, 2008 and 2012,MS Office.

PROFESSIONAL EXPERIENCE

Confidential

SQL DBA

Responsibilities:

  • Installed, Administered, maintained, troubleshot the SQL Server instances.
  • Setting up Test, Dev, Staging and Prod environments as per the requirement.
  • Monitored group mailboxes where we receive alerts and work on the same.
  • Worked alongside with development team and resolved issues.
  • RDP to the server and see for any cluster issues using windows RDP tool.
  • Monitored jobs processing & resolved any failures encountered.
  • Worked with the monitoring tool called NETCOOL, where all the alerts related to SQL server are monitored.
  • Worked on Implementation of end to end packages that included variables and parameters.
  • Worked with T-sql while doing performance tuning.
  • Knowledge of SSAS. Modular and MDM cubes.
  • Created few PowerShell scripts and regularly executed the same.
  • Ensured appropriate prioritization of tasks, complied with defined processes during task execution like promoting changes to production and coordinating with various developers.
  • Worked with Fact and Dimension tables and their performance tuning.
  • Always available for On-call support for critical business needs.
  • Engaged in deployment activities during releases.
  • Worked on ticketing tools such as Service now and HPSM.
  • Reviewed workloads and provided data model recommendations for better data load and access.
  • Identified long running SQL queries for tuning.
  • Developed, implemented, administered and maintained security and integrity of the Application databases.
  • Completed other duties, tasks and activities as they arise.
  • Strong skills in Installation, upgrade, backup and recovery, data migration, database maintenance.
  • Release management.
  • Performance tuning.
  • Liaised with IT and user community thus acting as a bridge to resolve issues and identify improvement areas.

Confidential

SQL DBA

Responsibilities:

  • Installed, Administered, maintained, troubleshot the SQL Server instances.
  • Setting up Test, Dev, Staging and Prod environments.
  • DB designing, backup and restoration strategies.
  • Database administration including backup/recovery strategies, DB design, coding best practices, trouble shooting and performance tuning.
  • Worked with T-sql
  • Thorough knowledge of indexes, index management and update statistics.
  • DB tuning, Application tuning and performance monitoring.
  • Thorough knowledge of ITIL process and standards. Participated in change control procedures.
  • Worked with SSIS packages whenever there was an issue and debug the same.
  • Provided on call support 24x7 to the client even on weekends.
  • Performance Tuning.
  • Production deployments.

Confidential

SQL DBA

Responsibilities:

  • Installed, Administered, maintained, troubleshot the SQL Server instances.
  • Setting up Test, Dev, Staging and Prod environments.
  • DB designing, backup and restoration strategies.
  • Database administration including backup/recovery strategies, DB design, coding best practices, trouble shooting and performance tuning.
  • Thorough knowledge of indexes, index management and update statistics.
  • Log shipping and Mirroring.
  • DB tuning, Application tuning and performance monitoring.
  • Thorough knowledge of ITIL process and standards. Participated in change control procedures.
  • Maintaining Security of all the users and granting them permissions.

We'd love your feedback!