We provide IT Staff Augmentation Services!

Sql Server Dba | Developer Resume

5.00/5 (Submit Your Rating)

SUMMARY:

  • Highly Accomplished SQL Server DBA | Developer (Total Exp. 11+ years) Database administrator (DBA) with extensive experience installing, configuring and supporting next - generation database solutions in SQL Server environments; an effective communicator with exceptional relationship management skills with the ability to relate to people at any level of business/management & significant experience working with steering committees;
  • Self-motivated team player with excellent verbal and writing communication skills & ability to learn things fast and a discerning mind;skills include:
  • Administering MSSQL Server 2012, 2008 R2 and 2005
  • Installation and configuration of SQL 2005,2008R2 and SQL 2012 builds and clusters
  • Data modeling, purging/archiving databases and Performance tuning
  • Security Auditing and maintaining server/ database level permissions
  • Database Backups/Restores and designing the disaster recovery plans to minimize downtime
  • Windows DNS, DHCP, Active Directory, Kerberos, Windows Administration and Group Policies
  • Installing and configuring Foglight and Spotlight
  • Partitioning, Log shipping, Linked Servers
  • Good hands on experience on Microsoft Operations Manager( MOM) and SCOM 2012
  • Snapshot and Transactional replication implementation & troubleshooting
  • DTS Packages, SQL Server Integration Service (SSIS) and SQL Server Reporting Service (SSRS)
  • Database Objects development (Tables, Views, Stored procedures, Cursors, T-SQL scripts and batch files)
  • Database Mirroring, Database Snapshot and Service Broker
  • Good knowledge on SQL Server database, t-log and memory architectures and internals
  • SQL debugging and query optimization
  • Good hands-on experience on all HA solutions
  • Data Security, Backup & Recovery
  • SQL server profiler and Database Tuning Advisor
  • Standby/Failover Administration
  • Ability to work in OLTP & OLAP environments
  • Good hands-on experience on SQL DBs in AWS and Azure.

PROFICIENT IN AN ASSORTMENT OF TECHNOLOGIES, INCLUDING;

Programming: C, C++, C#, Python, HTML

Operating System: WINDOWS 98|XP|2000|VISTA| and WINDOWS Server 2000, 2003, 2008 and 2012

Front-end: MS-OFFICE, MOM, Foglight and SQL Client Tools, Sharepoint Designing, Powershell

Backend: RDBMS Concepts, SQL Server 2000, 2005, 2008, 2008 R2 and 2012, MongoDB 3.0

Others: SCOM 2012, Foglight Deployment and Administration, CommVault configuration and administration, Azure Cloud, AWS

WORK EXPERIENCE:

Confidential

SQL Server DBA | Developer

Responsibilities:

  • Providing End to End SQL Server Administration Support to all the IT-managed MSSQL Servers.
  • Designed and Implemented database maintenance jobs for various database activities.
  • Performing SQL Server installations, SQL cluster builds, service pack upgrades and post-SQL build configurations on On-premise as well as on AWS EC2 instances.
  • Setting up database monitoring solutions TSQL scripts and SCOM 2012, checking error logs, checking the log file size and free space in the data files and drives.
  • Designing the DB team Online Sharepoint site for maintaining the DB Inventory, team technical, process and standards documents.
  • Migrating, maintaining and supporting MSSQL databases on AWS RDS and EC2 instances.
  • Planning storage capacity and accessing the hardware requirements for the upcoming requirements.
  • Working with powershell for automating day to day tasks and configuring alerts in SCOM 2012.

Confidential

SQL Server DBA | Developer

Responsibilities:

  • Performing regular server health checks before starting the business hours.
  • Worked on various Recovery Models, Performing Backups & Recovery of data.
  • Provided End to End SQL Server Administration Support to around 1500 SQL Servers.
  • Performing SQL Server installations, service pack upgrades and Commvault configuration.
  • Worked on setting up log shipping, database mirroring, transactional replication and building redundancy to eliminate single point of failure and troubleshooting Replication, Log shipping and SQL clustering issues.
  • Setting up and maintaining linked servers, replication and SQL cluster servers.

Confidential

Service Design Engineer

Responsibilities:

  • Involved in designing the Infrastructure for Vertex application.
  • Performing regular server health checks before starting the business hours.
  • Provided End to End SQL Server Admin Support to around SQL and Web Servers in FIT space.
  • Supporting applications and MS SQL Instances and databases in Azure.
  • Designed and Implemented database maintenance plans for various database activities.
  • Worked on setting up log shipping, database mirroring, SQL AlwaysOn, transactional replication and building redundancy to eliminate single point of failure.
  • Experience in Performing Cluster operations, failover and failback, adding dependencies and troubleshooting.
  • Troubleshooting functional/technical issues in the applications and raising bugs with the Engineering team.

Confidential

MSSQL DBA Support

Responsibilities:

  • Performing a role of SME/Primary DBA, handling about 15 GRITT applications.
  • Identifying and automating frequently performed activities at work.
  • Planning and configuring of MS SQL 2005/2008, SQL Cluster servers, SQL Litespeed.
  • Installing and configuring Foglight (a third-part monitoring tool).
  • Setting up and maintaining linked servers, replication and SQL cluster servers.
  • Troubleshooting Replication, Log shipping and SQL clustering issues.
  • Maintaining server and database level user security privileges.
  • Configuring and troubleshooting Service Broker and Database mirroring.
  • Working on work requests (WR) raised by LOB users to meet their needs meeting SLAs.
  • Uploading report files (.rdl) in SSRS report sites and SSIS packages/files (.dtsx) to meet the business needs.

Confidential

SQL Server DBA | Developer

Responsibilities:

  • Involved in Installing and Configuring of MS SQL 2000/2005, SQL Cluster servers, SQL Litespeed (a third party tool for SQL server backups and restores) and upgrading servers and Migrating databases from SQL Server 2000 to 2005/2008.
  • Maintained server and database level user security privileges.
  • Worked on performance issues and optimized SPs and queries.
  • Set up and maintained linked servers, replication and SQL cluster servers.
  • Involved in Troubleshooting Replication, Log shipping and SQL clustering issues.
  • Instrumental in Configuring and troubleshooting Service Broker and Database mirroring.
  • Set up and Monitored Backup jobs and DBA maintenance jobs using autosys tool.
  • Performed regular server health checks.

Confidential

SQL Server DBA | Developer

Responsibilities:

  • Installed and Configured SQL Server 2000/2005 Stand alone, Clustered and Multi-Instance Servers and applied Security Patches.
  • Experienced in working with Fail Over and Fail Back clusters.
  • Provided End to End SQL Server Administration Support to around 3000 SQL Servers.
  • Worked on automating the regular backup of the production database and developed a perfect database backup strategy. Worked on scheduling jobs, executing scripts, building and maintaining servers as and when required.
  • Designed and Implemented database maintenance plans for various database activities.
  • Worked extensively on monitoring the database, checking error logs, checking the log file size and free space in the data drives, connectivity of the databases in response to the MOM Alerting System.
  • Worked on DTS Packages, BCP and SSIS in migrating data from different systems.
  • Configured, Monitored and Trouble shooter replication and log shipping ensuring data redundancy.

We'd love your feedback!