Senior SQl DBA/Team Lead
Resume:
Debatirtha Basu
[pic]
PROFESSIONAL SUMMARY:
. Over 10+ years of experience as a MS-SQL Server DBA and involved
in general Database Administration, Analysis and Support of MS SQL
Server 2000/2005/2008 servers and databases.
. Expertise in SQL Server 2005 and 2008 Enterprise Edition,
experience with SQL Server Enterprise Manager, SQL Query Analyzer,
SQL Server Management Studio and Business Intelligence Development
Studio, scheduling jobs with SQL Server Agent, SQL Server Storage
Structures, Index and Security Architecture and SQL Profiler.
. Expertise in MS SQL Server Installation, Configuration, Migration
and Maintenance, applying patches.
. Experienced in implementing advanced Backup and Recovery
strategies.
. Experienced in Performance Tuning, Query Optimization,
Client/Server Connectivity, and Database Consistency Checks using
DBCC Utilities.
. Configured and Managed SQL Server 2000, 2005, 2008 and 2008R2
instances and databases using SQL Management Studio, SQL server
configuration Manager and SQL Sever Surface Area Configuration
Manager.
. Extensive experience in SQL Server BI suite - SSIS, SSRS and SSAS
. Experienced in developing T-SQL Stored Procedures, Queries, and
Triggers.
. Implemented SQL Server High Availability solutions including Log
Shipping and Database Mirroring.
. Knowledge of Redundant Array of Independent Disks (RAID) system and
levels.
. Expertise in automating routine database maintenance & monitoring
jobs using SQL Server Agent.
. Database monitoring using Quest Spotlight and SQL Sentry
. Database backup using LiteSpeed.
. Extensive knowledge of Windows Server 2003 and 2008 operating
systems, dealing with such issues as Active Directory, domain
access, user profiles, hardware/software installation &
configuration, and sharing resources.
. Analytical, highly versatile, outstanding interpersonal and
communication skills; team-oriented individual; skillful in
translating strategy into actions by organizing tasks, building and
sustaining relationships and leading team members from project
inception to completion under strict time and resource constraints.
. Good team player with excellent communication and interpersonal
skills.
TECHNICAL SKILLS
Databases SQL Server 2000/2005/2008/2008R2, MS Access 200x
Database Enterprise Manager, Management Studio, Query Analyzer,
Tools Profiler, Tuning Wizard, Database Maintenance Plan
Wizard, DTS, SSIS, SSRS,SSAS
Operating Windows 2000/2003/2008, Win XP, Unix, Linux
Systems
PROFESSIONAL EXPERIENCE
SHL, Alpharetta, GA June 2013 - Till
date
Sr. SQL Server Enterprise DBA/Team Lead
Description:
SHL is the leader in talent measurement solutions, driving better business
results for clients through superior people intelligence and decisions -
from hiring and recruiting, to employee development and succession
planning. SHL was acquired in 2012 by CEB, the leading member-based
advisory company. Offering the broadest global footprint in the industry,
SHL deploys solutions in more than 150 countries and maintains a local
presence in more than 50 countries.
Responsibilities:
. Managed Server Instances of different releases - 2005, 2008 and
2008R2.
. Managed SQL Server security, server and database roles, permissions
and credentials.
. Configured SQL Server instances and databases using SQL Management
Studio, SQL Server Configuration manager.
. Design database and models based on new application enhancements
. Setup database mail so that mail notification can be sent in the event
of maintenance plan failure.
. Managed indexes using Database Engine Tuning Advisor.
. Support for Web development team projects
. Writing T-Sql codes, stored procedures for addning new functionality
to the application
. Setup and maintain both push and pull subscriptions.
. Performed optimization of SQL queries using Execution Plan.
. Maintenance of clustered and non-clustered indexes.
. Hands on experience in developing Custom Report and different types of
Tabular Reports, Matrix Reports, Ad hoc reports and distributed
reports in multiple formats using SQL Server 2005/2008 Reporting
Services (SSRS).
. Managed SSRS including setup, encryption, report deployments and
setting up subscriptions.
. Develop backup & restore plans for database and the log as needed
. Monitor server space usage and generate reports.
. Restore Development and UAT databases as and when needed.
. Performance optimization and normalization of database
. Maintain Disaster recovery strategies for the database and fail-over
methods.
. Monitor SQL servers and setup alerts using Quest Spotlight and SQL
Sentry
. Used various DMVs like wait stats and index usage for performance
tuning.
Environment: SQL Server 2005/2008/2008R2, Windows 2003/2008, MS Office
tools
Prommis Solutions, Atlanta, GA Dec.
2011 -May 2013
SQL Database Team Lead
Description:
Prommis Solutions is leading provider of technology-enabled processing
services for default resolution sector of the residential mortgage
industry. Prommis currently provides support services for foreclosure
processing in 19 states and support services for bankruptcy and loss
mitigation processes in 50 states.
Responsibilities:
. Managed over 25 SQL Server Instances of different releases - 2000,
2005, 2008 and 2008R2.
. Managed SQL Server security, server and database roles, permissions
and credentials.
. Upgraded SQL SERVER 2005 instances and to SQL Server 2008 and 2008R2
release using Database Upgrade Advisor Report.
. Configured SQL Server instances and databases using SQL Management
Studio, SQL Server Configuration manager.
. Conduct weekly team meeting on the progress of the DB initiatives, DB
Server incidents/ uptimes/ downtimes, server hardware capacity
upgrades, status on the roll-out of service packs/ hot fixes/ patches,
and revisiting db best practices document, and new db support/data
services requirements.
. Designed, coded and implemented a standard daily and weekend
maintenance plan across all the servers.
. Managing Datawarehouse project
o Datamart design
o Data modeling
o ETL specifications
o Keep the stake holders updated with the progress of the project
. Setup database mail so that mail notification can be sent in the event
of maintenance plan failure.
. Managed indexes using Database Engine Tuning Advisor.
. Support for Web development team projects
. Periodically reviewed code written by developers
. Load data into the database from text files and other database and
file systems
. Maintained Log Shipping for disaster recovery. Configured High
Availability Asynchronous Database Mirroring with Witness Server
instance.
. Set up and support Replication between Production and Reporting
databases.
. Experienced in implementing and troubleshooting Transactional
Replication using the setup from snapshot and also from backup.
. Setup and maintain both push and pull subscriptions.
. Maintain synchronization between the publisher, distributor and the
subscriber in Transactional Replication.
. Created new replications and addressed the Replication Issues to
maintain the data between the servers.
. Performed optimization of SQL queries using Execution Plan.
. Maintenance of clustered and non-clustered indexes.
. Manage DTS packages from SQL Server 2000 in SQL 2005.
. Converted DTS packages to SSIS 2008 and SSIS 2005 to SSIS 2008.
. Designed and created different ETL packages using SSIS from SQL,MS
ACCESS,EXCEL and other sources to SQL server as destination and vice
versa.
. Hands on experience in developing Custom Report and different types of
Tabular Reports, Matrix Reports, Ad hoc reports and distributed
reports in multiple formats using SQL Server 2005/2008 Reporting
Services (SSRS).
. Managed SSRS including setup, encryption, report deployments and
setting up subscriptions.
. Develop backup & restore plans for database and the log as needed
using SQL LiteSpeed and also native sql server.
. Monitor server space usage and generate reports.
. Restore Development and UAT databases as and when needed.
. Performance optimization and normalization of database
. Maintain Disaster recovery strategies for the database and fail-over
methods.
. Monitor SQL servers and setup alerts using Quest Spotlight
. Used various DMVs like wait stats and index usage for performance
tuning.
Environment: SQL Server 2000/2005/2008/2008R2, Windows 2003/2008, UNIX, MS
Office tools, Excel Macros.
NexTraq (formerly Discrete Wireless), Atlanta, GA
Feb. 2010 - Nov.2011
Sr. SQL Server Database Administrator
Description:
NexTraq provides a GPS vehicle tracking and fleet management solutions in
the industry. The system is a 100% web based application that enables
service and distribution businesses to proactively manage fleet operations
while reducing operational costs and maximizing revenue.
Responsibilities:
. Designed and implemented large volume data updates in the range of
Terabytes of data. Currently the database handles 5 to 6 million
transactions per day.
. Managed multiple SQL Server Instances.
. Managed SQL Server security, server and database roles, permissions
and credentials.
. Upgraded SQL SERVER 2005 instances and to SQL Server 2008 release
using Database Upgrade Advisor Report
. Configured SQL Server instances and databases using SQL Management
Studio, SQL Server Configuration manager.
. Conduct weekly team meeting on the progress of the DB initiatives, DB
Server incidents/ uptimes/ downtimes, server hardware capacity
upgrades, status on the roll-out of service packs/ hot fixes/ patches,
and revisiting db best practices document, and new db support/data
services requirements.
. Managed indexes using Database Engine Tuning Advisor.
. Maintain the table level partition using sliding window technique.
. Support for Web development team projects
. Periodically reviewed code written by developers
. Load data into the database from text files and other database and
file systems
. Setup and maintain SQL cluster using mount points
. Set up and support Replication between Production and Reporting
databases.
. Consolidated and upgraded various small applications running on Access
97 and Excel to use SQL Server 2008 as backend database, which made it
easy to provide access to new users and troubleshoot any errors, much
faster, saving time and money.
. Experienced in implementing and troubleshooting Transactional
Replication using the setup from snapshot and also from backup.
. Maintain synchronization between the publisher, distributor and the
subscriber in Transactional Replication.
. Created new replications and addressed the Replication Issues to
maintain the data between the servers.
. Performed optimization of SQL queries using Execution Plan.
. Maintenance of clustered and non-clustered indexes.
. Used Maintenance plans and SQL server Agent to automate database tasks
and set up alerts to notify operators in case of critical conditions
. Manage DTS packages from SQL Server 2000 in SQL 2005.
. Converted DTS packages to SSIS 2008 and SSIS 2005 to SSIS 2008.
. Designed and created different ETL packages using SSIS from SQL,MS
ACCESS,EXCEL and other sources to SQL server as destination and vice
versa.
. Hands on experience in developing Custom Report and different types of
Tabular Reports, Matrix Reports, Ad hoc reports and distributed
reports in multiple formats using SQL Server 2005/2008 Reporting
Services (SSRS).
. Experienced in generating parameterized reports and drill through
reports using SSRS.
. Develop backup & restore plans for database and the log as needed
using SQL LiteSpeed and also native sql server.
. Monitor server space usage and generate reports.
. Restore Development and UAT databases as and when needed.
. Design and implementation of database maintenance plan
. Performance optimization and normalization of database
. Job, Scheduling, batch, alert and E-mail notification setting.
. Maintain Disaster recovery strategies for the database and fail-over
methods.
. Monitor SQL servers and setup alerts using SQL Sentry and also
provided management reports out of SQL Sentry.
. Used SQL Sentry to provide various performance counter reports and
compare different timeframes.
Special Project: Implementing Dashboard capability
. Capacity planning for the project
. Managed weekly meetings for all the stake holders
. Facilitate decision making processes during weekly meetings
. Design DataWarehouse including Star Schema and Data Modelling
. Created SSIS packages for populating the Facts and Dimensions on
specific intervals related to various time zones.
. Design and develop Olap database using Analysis Services (SSAS).
. Implemented MOLAP database
. Created many to many dimensions wherever necessary
. Design and implemented the cube partition strategy
. Implemented the cube security privileges
. Created all the MDX queries
. Design and implemented cube processing and backup schedule
Environment: SQL Server 2000/2005/2008, Windows 2003, UNIX, MS Office
tools, Excel Macros.
UPS (United Parcel Services), Alpharetta, GA
Aug. 2008 -Jan. 2010
Sr. SQL Server Database Administrator
Description:
UPS is a global company with one of the most recognized and admired brands
in the world. They are the world's largest package delivery company and a
leading global provider of specialized transportation and logistics
services.
Responsibilities:
. Designed and implemented large volume data updates.
. Managed multiple SQL Server Instances each with over 20 databases.
. Managed SQL Server security, server and database roles, permissions
and credentials.
. Upgraded SQL SERVER 2000 instances and databases to SQL Server 2005
release using Database Upgrade Advisor Report
. Configured SQL Server instances and databases using SQL Management
Studio, SQL Server Configuration manager.
. Managed indexes using Database Engine Tuning Advisor.
. Support for Web development team projects.
. Review and provide modifications to the code written by developers.
. Load data into the database from text files and other database
systems.
. Provide High Availability solution using Mirroring.
. Consolidated and upgraded various small applications running on Access
97 and Excel to use SQL Server 2000 as backend database, which made it
easy to provide access to new users and troubleshoot any errors, much
faster, saving time and money.
. Created new replications and addressed the Replication Issues to
maintain the synchronization between the publisher and the subscriber.
. Performed optimization of SQL queries using Execution Plan and SQL
Server Profiler.
. Maintenance of clustered and non-clustered indexes.
. Used Maintenance plans and SQL server Agent to automate database tasks
and set up alerts to notify operators in case of critical conditions
. Manage DTS packages from SQL Server 2000 in SQL 2005.
. Maintain Disaster recovery strategies for the databases.
Project: Carbon Footprint Calculator - Provide a calculator through which
UPS will generate carbon footprint analysis for its enterprise customers.
. Gather requirements
. Capacity planning for hardware and software
. Designed the database
. Provide various stored procedures and lookup tables for the front end
team.
. Designed all the SSIS packages which will extract data from various
other UPS systems like DB2, SQL, Oracle and Access. Also created the
stored procedure which will use all these data to derive various
factors depending upon the mode of transportation to be used for the
footprint calculations.
. Developed all the Custom Reports and different types of Tabular
Reports, Matrix Reports, Ad hoc reports and distributed reports in
multiple formats using SQL Server 2005 Reporting Services (SSRS).
. Was involved in proving all test cases as needed for third party
verification of the calculator and the methodology.
. Generated parameterized reports and drill through reports using SSRS.
. Develop backup & restore plans for the database.
. Develop and maintain the archiving strategy of old data.
. Monitor server space usage and generate reports.
. Restore Development and UAT databases as and when needed.
. Design and implementation of database maintenance plan
. Performance optimization and normalization of database
. Job, Scheduling, batch, alert and E-mail notification setting.
Environment: SQL Server 2000/2005/2008, Windows 2003, UNIX, MS Office
tools, Excel Macros.
Builders Insurance, Vinings, GA Jan.
2007 -July 2008
SQL Server Database Administrator
Description:
Builders Insurance Group is a leading underwriter of workers' compensation
and general liability insurance throughout the Southeast. The company is
endorsed by the Home Builders Association of Georgia and counts thousands
of members of the homebuilding community among its policyholders.
Responsibilities:
. Upgraded SQL SERVER 2000 instances and databases to SQL Server 2005
release using Database Upgrade Advisor Report
. Configured SQL Server instances and databases using SQL Management
Studio, SQL Server Configuration manager.
. Setup SQL Server stand database using log shipping for high
availability.
. Maintained Log Shipping for disaster recovery. Configured High
Availability Asynchronous Database Mirroring with Witness Server
instance.
. Set up and supported replication between production and reporting
databases using transaction replication.
. Create database objects including tables, triggers, views, stored
procedures, indexes, defaults and rule.
. Managed SQL Server security using various modes of authentication,
server and database roles, permissions and credentials.
. Performed optimization of SQL queries using Execution Plan, SQL
profiler and Database Tuning Advisor.
. Maintenance of clustered and non-clustered indexes.
. Used Maintenance plans and SQL server Agent to automate database tasks
and set up alerts to notify operators in case of critical conditions.
. Used DTS Packages for data import and export data from SQL Server to
Access, text and EXCEL files.
. Perform database consistency checks at regular intervals.
. Monitor SQL Server activity through profiler.
. Monitor server space usage and generate reports.
. Design and implementation of database maintenance plan.
. Performance optimization and normalization of database.
. Tuning and optimizing queries and indexes.
. Job, Scheduling, batch, alert and E-mail notification setting.
. Maintain Disaster recovery strategies for the database and fail-over
methods.
. Monitor SQL Server log files.
Environment: SQL Server 2000/2005, Windows 2003, UNIX, Excel Macros.
Atlantic American Corp., Atlanta, GA Jan.
2004 - Dec. 2006
SQL Server Database Administrator
Description:
Atlantic American is a holding company in the field of health, property and
casualty insurance industry.
Responsibilities:
. Maintaining Installation, Backup Automation & Recovery.
. Performance tuning using performance tool, SQL profiler and Dashboard
Reports
. Performed Database Integrity Checks, updated Database Statistics and
performed Re-indexing.
. Database consultant for design and performance tuning
. Upgrading Service packs & patches, Maintaining Security Policies etc.
. DB Maintenance Activities such as Re-index, Update Statistics, Check DB
. Automation of DB Disk Space and restoration of previous day backup
. Automation of checking SQL services and mail alert on stoppage
. Job creation, automation & maintenance & troubleshooting on failures
. Database Mail Configuration and Alerting through mail in SQL 2000
. Database Security such as removing unwanted privileges, logins for the
users
. Implementation of different security policies by granting Permissions to
groups and different objects and defining different roles and logins
. Query tuning, Stored procedures optimization etc
Environment: SQL Server 2000 & Windows 2000
AIGT (a group of AIG), Parsippany, NJ Aug.
2002- Dec. 2003
SQL Server Database Administrator
Description:
American International Group, Inc., through its subsidiaries, provides
insurance and financial services in the United States and Internationally.
Responsibilities:
. Administrating the SQL Server 2000 environment.
. Maintaining Installation, Backup Automation & Recovery
. Performance tuning using performance tool, SQL profiler
. Database consultant for design and performance tuning
. Upgrading Service packs & patches, Maintaining Security Policies etc.
. DB Maintenance Activities such as Re-index, Update Statistics, Check
DB
. Automation of performance log start & stop and storing into SQL Tables
& files
. Automation of DB Disk Space and restoration of previous day backup
. Automation of checking SQL services and mail alert on stoppage
. Job creation, automation & maintenance & troubleshooting on failures
. Database Mail Configuration and Alerting through mail in SQL 2000
. SQL Mail Configuration and Alerting through mail in SQL 2000
. Database Security such as removing unwanted privileges, logins for the
users
. Implementation of different security policies by granting Permissions
to groups and different objects and defining different roles and
logins
. Query tuning, Stored procedures optimization etc
Environment: SQL Server 2000,Windows NT.
Caterpillar Inc., Peoria, IL
Apr.1998 - July 2002
Database Analyst
Description:
Caterpillar Inc. is the world's biggest maker of earth-moving equipment
and heavy duty engines
Responsibilities:
. Performed backups, DBCC utilities, updated index statistics, monitored
database and disk space, security issues and scheduled tasks.
. Created the maintenance plan for optimization and integrity check for
all SQL servers.
. Worked on creating maintaining DTS packages for data extraction.
. Created regular backups of databases and transaction logs.
. Created & maintained databases, table spaces, users, tables, indexes,
store procedures, roles, profiles, partitions and other schema
objects.
. Involved in creation of Stored Procedures to support the front end web
teams.
. Created various management reports using SSRS 2000.
Environment: MS SQL Server 2000
> EDUCATION
Bachelors Of Engineering,Bangalore,INDIA.
[pic][pic][pic][pic][pic][pic][pic][pic][pic][pic][pic][pic][pic][pic][pic][pic]
[pic][pic][pic][pic][pic][pic][pic][pic][pic][pic]
Contact this candidate