Experience

NEOGOV

• United States
• Software Development
• 400 - 500 Employee

• SQL Server DBA

  • Jun 2012 - Present



EQUATOR®, An Altisource Business Unit

• Luxembourg
• Information Technology & Services
• 1 - 100 Employee

• SQL Server DBA

  • Sep 2009 - May 2012

  •Provided support to 75 database Servers having a volume of 15 terra bytes with an average throughput of 2 million transactions per day •Provided 24x7 support on an on-call rotation basis •Worked on Performance Tuning and Optimizing Queries by analyzing Execution Plans and Re-designing Indexes. •Configured and administered Transactional Replication •Configured and administered various high availability and Disaster recovery technologies such as Log Shipping, Clustering and Database Mirroring •Involved in planning a implementing Disaster Recovery Exercise •Involved in Capacity Planning and worked with storage team to add new storage space as needed •Analyzed and setup various Alert jobs on servers for pro-active monitoring. •Scheduled Backups of databases and recovered them periodically to verify integrity of Backups •Involved in Partitioning tables that have huge data and accessed more •Managed Security by using login/groups and assigning appropriate permissions Show less



IQuest Solutions Corp.

• SQL Server DBA/Developer

  • Feb 2009 - Aug 2009

  •Provided support to 50 database Servers. Support included Production, QA and Development •Worked on Performance Tuning and Optimizing Queries by analyzing Execution Plans and Re-designing Indexes •Scheduled Backups of databases and recovered them periodically to verify integrity of Backups •Developed SSIS packages to transform data between various data sources •Configured and administered Transactional Replication •Involved in Capacity Planning and adding new storage space as needed •Worked on evaluating various high availability technologies such as Log Shipping, Clustering and Database Mirroring •Configured Linked Servers •Managed Security by using login/groups and assigning appropriate permissions •Wrote complex T-SQL queries and Stored Procedures for the reports •Upgraded databases from 2000 to SQL 2005 and SQL 2008 •Installed and Configured SQL Server 2005/2008 on Stand-Alone and Active/Passive clusters on Windows 2003 Show less



Northwest Missouri State University

• United States
• Higher Education
• 700 & Above Employee

• Student Assistant/Database Systems

  • Aug 2007 - Dec 2008

  •Assisted the Professor in Database Systems course •Conducted help sessions in the evening to assist students with Database System course •Helped the students to clarify database concepts like Normalization, JOINS, Entity Relationships and other SQL queries •Involved in planning the course schedule •Involved in preparing Exam questions •Involved in Grading the Exams •Involved in Setting up the database server, created logins and granted required permissions on the database to the new students every semester Show less



NTT Ltd.

• United Kingdom
• IT Services and IT Consulting
• 700 & Above Employee

• Software Engineer/DBA/Developer

  • Oct 2005 - Dec 2006

  •Designed Logical and Physical model using Erwin •Worked on writing complex Stored procs for reports •Involved in Performance Tuning using performance monitor and SQL Profiler •Involved in Optimizing queries by looking at the query plan & cost •Analyzed and Redesigned Indexes •Developed SSIS packages to transform data from various data sources •Imported and exported data from heterogeneous sources using various techniques like BCP and DTS •Involved in Capacity planning for Database Servers •Used Constraints and Triggers to enforce Business rules •Managed Security by using login/groups and assigning appropriate permissions Show less