We provide IT Staff Augmentation Services!

Sr. Database Analyst Resume

NY

Professional Summary

  • Over 8 years of Experience in design, development, database administration and production support of relational databases and business applications.
  • Experience in setting up new servers, installing, upgrading and migrating database applications in SQL Server.
  • Good experience working with very large databases and Performance tuning.
  • Experienced in working with ETL tools like SSIS.
  • Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using T-SQL
  • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
  • Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
  • Recovering the databases from backup in disasters.
  • Backup client databases and perform database restore and run consistency checks from SQL Server and application. Performs and monitors daily database operations and set-up backup schedules.
  • Monitor the status of Maintenance jobs – schedule to run daily and on weekends (tasks like, creating Databases, Shrink Database, and Database complete backup).
  • Maintenance of Log shipping.
  • Proactively working on Performance and Blocking issues on servers by auditing Databases.
  • Maintain Security Administration and High Availability( Replications, Log Shipping, mirroring and clustering)
  • Experience on always-on high availability.
  • Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.
  • Experience in applying patches and service packs to keep the database at current patch level.
  • Positive attitude in accepting new technologies and a great willingness to learn new innovations and skills in accordance with the dynamic technologies.

Technical Skills

Technologies

SSIS,SSRS

Operating Systems

Windows Server 2003/2008

Databases

MS SQL Server 2012/2008/2005/2000 ,MYSQL 5.5

Web Servers

IIS 6.0 ,7.0

Tools

ITIL,LiteSpeed,MSE, TOAD, workbench

Professional Experiences

Confidential

Title: Sr. Database Analyst

Roles & Responsibilities

  • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
  • Recovering the databases from backup in disasters.
  • Backup client databases and perform database restore and run consistency checks from SQL Server and application. Performs and monitors daily database operations and set-up backup schedules.
  • Monitor the status of Maintenance jobs – schedule to run daily and on weekends (tasks like, creating Databases, Shrink Database, and Database complete backup).
  • Maintenance of Log shipping.
  • Backups and restoring processes using SQL LiteSpeed
  • Password Reset Activities on production and pre-production servers.
  • Bringing the Microsoft servers into Standard format by performing File Movements etc.
  • Proactively working on Performance and Blocking issues on servers by auditing Databases.
  • Maintain Security Administration and High Availability( Replications, Log Shipping and mirroring)
  • Performing security management by maintaining roles, privileges, and user profiles. Add/Remove users from many different Security Groups in our domain (Auto groups).
  • Run Scripts on production databases that are requested by the Redmond Teams. Also troubleshoot if there are any minor issues in the script, if the script doesn't give the desired output.
  • Submit/Follow up requests to different teams on various issues.
  • Create Service Request tickets for customer issues that come in and see to it that it does not get out of SLA (Service Level Agreement).
  • Password Reset Activities on production and pre-production servers.
  • Back up the databases and restoring the databases.

Technologies: SQL Server 2000\2008\2012

Confidential

Title: Technology Lead

Roles & Responsibilities

  • Recovering the databases from backup in disasters.
  • Monitor the status of Maintenance jobs – schedule to run daily and on weekends (tasks like, creating Databases, Shrink Database, and Database complete backup).
  • Maintenance of Log shipping.
  • Password Reset Activities on production and pre-production servers.
  • Migrating tables from sql server to MySQL using SSIS.
  • Configured packages using SSIS to import the data in to MySQL database from source servers like sql server.
  • Proactively working on Performance and Blocking issues on servers by auditing Databases.
  • Maintain Security Administration and High Availability( transactional Replication)
  • Run Scripts on production databases that are requested by the Redmond Teams. Also troubleshoot if there are any minor issues in the script, if the script doesn't give the desired output.
  • Import and export data into different table using import and export wizard.
  • Installed and configured MySQL on Linux and Windows environments.
  • Managing/Troubleshooting MySQL issues in production and development environments on Linux.
  • Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
  • Effectively configured MySQL Replication as part of HA solution.
  • Performed MySQL Replication setup and administration on Master-Slave and Master-Master
  • Worked on application bugs created by users.

Technologies: SQL Server 2008, MYSQL 5.5, SSIS, Visual Studio 2010.

Confidential

Title: Technology Analyst

Roles & Responsibilities

  • Hands-on experience in installing and configuring MS-SQL SERVER 2005.
  • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
  • Recovering the databases from backup in disasters.
  • Backup client databases and perform database restore and run consistency checks from SQL Server and application. Performs and monitors daily database operations and set-up backup schedules.
  • Monitor the status of Maintenance jobs – schedule to run daily and on weekends (tasks like, creating Databases, Shrink Database, and Database complete backup).
  • Maintenance of Log shipping.
  • Creating Linked servers.
  • Maintain Security Administration and High Availability( Replications and Log Shipping)
  • Created indexes on the tables for faster retrieval of the data to enhance database performance
  • Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE

Technologies: SQL Server 2000\2005

Confidential

Title: Associate DBA

Roles & Responsibilities

  • Hands-on experience in installing and configuring MS-SQL SERVER 2000/2005
  • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
  • Recovering the databases from backup in disasters.
  • Backup client databases and perform database restore and run consistency checks from SQL Server and application. Performs and monitors daily database operations and set-up backup schedules.
  • Monitor the status of Maintenance jobs – schedule to run daily and on weekends (tasks like creating Databases, Shrink Database, and Database complete backup).
  • Maintenance of Log shipping.
  • Maintain Security Administration and High Availability(Replications and Log Shipping)
  • Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
  • Transferring data between development and production environment (sync up environment techniques).
  • Worked as a developer in creating complex stored Procedures, SSIS packages, triggers, Cursors, tables, and views and other SQL joins and statements for applications.
  • Worked on SSRS to handle Ad-hoc requests.

Technologies: MS SQL server 2000, TOAD, DTS, T-SQL.

Hire Now