Sql Server Project
Resume:
MANINDER SINGH
MCDBA / MCITP (**** DBA) / MCITP (2008 DBA)
*********@*****.***
http://www.dbanation.com
SQL Server Database Administrator
Secure / Error free and on-demand information system leads to a stress free
and high performing organization(s). But when the information resides in
Databases, you need a Senior DBA to take control and provide its years of
hands-on experience to Build and Implement Best Practices for the
database(s) and to make sure systems operate efficiently and securely. I
bring a new Feel and Excellent Career Experience to your organization /
team with 11 years as a SQL Server DBA/Developer, to perform Database
Management and compliance Strategies on the Database Servers. I am a
Certified MCDBA / MCITP (2005 DBA) and MCITP (2008 DBA)
Career Objective:
I am seeking a challenging and Effective position as a Senior SQL Server
DBA / Lead.
Experience Summary:
. Over 14 years of experience, including 11 years as DBA in development and
PRODUCTION environments.
. Ensure SQL Server database systems operate efficiently and securely while
minimizing downtime.
. Reduced the project cost by 150K+ by reusing existing hardware and
licensing strategies/virtualized and upgrade servers to meets corporate
standards within budget.
. Spearheaded the corporate Project to Mass migration of Access Project to
SQL Server 2005 and 2008 and Migration of SQL Server Legacy 7.0 and 2000
databases and server to SQL Server 2005 and 2008.
. Leading a Project to Migrate a HP Tandem-Non Stop Warehouse to SQL Server
2008, using SSIS for ETL and SSAS for BI Processing using Cubes,
including SSRS for Reporting.
. Proficiency in performance monitoring and tuning.
. Wrote several internal documents pertaining to Base Build
scenarios/Database Security/migration/Support for Database servers.
. Hands-on in Architecture and Development Techniques using ERWIN/VISIO.
. Implemented a database change control process, which includes strategies
of moving database objects from development into production for
development/QA and Production environments.
. Implemented and SET Course of action for making Database Servers SOX
Compliance.
. Implemented Database Server Auditing Techniques, which lead to Safe and
Secure Data Practices and Help Script Database documentation as and when
required.
. I am a Detailed Oriented Person, with Best solution Turnaround times for
Database issues (Database Server issues).
. Firm believer in Team Work and have worked with several Teams and got the
project Implemented on Time and within budgets.
. I have good Knowledge in SAN Technologies (EMC Clarion CX Series and IBM
DS 8000)
. Good Understanding of (Networking Structure and Techniques/ Security
Management)
. I am a Certified MCDBA / MCITP(2005 and 2008)
. Superior communication, presentation, analytical and problem solving
skill. Work well with all levels of business
. Managing SSAS/SSIS/SSRS Environments. (Deployment / Security and
Performance)
. Implemented and Managing High Availability (Clustering / Replication /
Mirroring)
. Designed and Implemented Disaster Recovery Strategies.
. Handled Oracle Performance Tuning and DR Strategies.
. Superior communication, presentation, analytical and problem solving
skill. Work well with all levels of business.
Qualifications:
. 16 years of Education of which 4 years Full time Bachelors of Computer
Engineering
Certifications:
. MCDBA / MCITP (2005 DBA & 2008 DBA)
Professional Experience:
Allegheny Technologies Pittsburgh PA JAN 2006 to Till Date
Senior Database DBA/Architect (with Oracle Backup)
. Streamlined Database Change control process and procedures.
. Implemented SOX Compliance Strategies for Financial SQL server Database
servers.
. Being a PRINCIPLE SQL Server DBA, I was responsible for Multiple Database
Servers, including SQL Servers (SQL Server 2000 to 2008) and 4 Oracle
Servers (10g and 11g). Managed a Cumulative Database size of 3.5 TB.
(Including 2.5TB of Production Databases).
. Migrated 50+ Projects from MS. Access to SQL Server and Migrated 20+ SQL
Server 2000 to 2005 and SQL 2008 including SSAS/SSIS/SSRS. Implemented
Virtualization and consolidated SQL Server 2005 Development environment
using VMWARE.
. ETL of Data from Mainframe (IBM) / Tandem non-Stop and other
heterogeneous sources to SQL Server 2005 and 2008 Servers. Created /
Managed DTS / SSIS Packages for the ETL Processes. Performance Tuned
Several SSIS Packages, reducing the Time to Execute, to reasonable
limits.
. Managed SQL Server Performance Tuning using automated jobs and Custom
SSIS Packages including windows perfmon.. for capturing performance data
also using Event Viewer and SQL Error Logs and custom Logs.
. Creating SSIS/SSRS Packages & Reports for Database Administrative Tasks.
. Proficiency in SQL Server Performance Tuning. As the Principle SQL Server
DBA, I was responsible for handling all Support Calls for Database
Servers. I have the Best Database Server Solution Turnaround Time
including user Queries. Effective use of SQL DMV's for Performance Tuning
tasks. Managing Index Fragmentation and Protocol type performance issues,
including database corruption and SQL Server Clustering/Replication
Issues./Managing and resolve Blocking-Deadlock issues/Query Execution
Plan Analysis for query performance tuning.
. Handling Shared as well as dedicated Database Servers.
. Involved in Database Design including concepts/ Scoping / Scaling Plans
and worked with Teams to define database requirements to optimize any
future growths.
. Worked with IBM DS8000 Ent. SAN and EMC clarion CX4-480. Defining
Database Server RAID Parameters and Space usage /requirements for
performance enhancements.
. Performance Tuning of T-SQL Code. Helping Developers when required.
Documentation for Process Control and Procedures.
. Implemented / Revised Disaster Recovery Strategies.(Including Managing
Offsite backup and Storage).
. Implement high availability solutions to protect production data from
disastrous incidents. (Implemented Clustering (AA and AP) / Replication /
Database Mirroring / Log-Shipping).
. Managed SharePoint Server backend and Small Farm Planning and
Implementations.
. Keeping Servers well informed and Tuned with regular patching and
performance baseline counters implementation.
. Using SQL Server Error Logs / Event Viewers / SQL Server Profiler / SQL
Server Auditing Features and planning/writing custom Logs to track
performance incidents.
. Involved in Database Architecture with Logical/Physical Schema design and
Architecting SSAS based Data warehouse environments.
. Able to work under pressure and deliver in or under timelines and on-
call (24x7)
. Among the other Major applications Backend I administered some are MAXIMO
/ JD-Edwards / PLUM Intranet / MS Forecaster / ProClarity / SharePoint
Servers / Various Intranet applications.
INTEL Corp, FOLSOM, CA JAN 2005 - DEC 05
Sr. SQL Server DBA
. Installation and configuration of SQL Servers / Created new databases.
. Involving in importing and exporting Data using DTS and Import/Export
Wizard from heterogeneous systems.
. Implemented A/A and A/P Clustering on Windows 2000 EE and SQL Server 2000
EE.
. Implemented and maintained Transaction Replication/log-Shipping on SQL
Server 2000 servers.
. Managed multiple projects at any given time. Worked across 20 diff
project.
. Data Modeling using Erwin, Reverse/Forward Engineering Techniques.
Creating ER Diagrams. Creating Logical / Physical Designs.
. Reorganized databases and sized database objects to meet standards and
improve performance by 30%
. Performance tuning of SQL statements and SQL Code reviews
. Work with SQLDevelopers to enhance code and naming conventions
implementation.
. Design code (triggers) to enforce business rules and maintain Data
integrity on production server.
. Handled database server tuning, application tuning, maintaining
documentation, and capacity planning / database security.
. Managed REMEDY Backend Server for Performance tuning with high
Availability with DB size of 900GB.
. Documented the new procedures for base build of SQL Server 2005 database
servers and base configuration, which eventually became the company
standard for implementing SQL Server 2005 servers.
. Maintained SQL Server Analysis Server which serviced companywide retail
reporting.
. Monitoring Alerts / JOBS and Maintenance Plans for High Availability
support for migration of objects
METLIFE, Bridgewater, NJ OCT 2003 to DEC 04
Lead SQL Server Database Administrator
Senior SQL Server DBA / ETL Architect. Involved in design, administration
and replication of SQL Server Database(s) including HR, Benefits, Payroll,
and Finance. Administered 80 Database SQL Server installations. Hands on
Involvement in Multiple Projects during the tenure of the contract, while
Designing and Implementing Data-Warehouse Projects for internal Analysis
use. Implemented Best Practices for SQL Server Database servers.
AXA Financials, NYC New York AUG 2002 to SEPT 2003
SQL Server DBA
Worked as a Database Administrator involved in Planning, Design,
Implementation of Enterprise Security through AD Management and Database
Security Implementations. Data Warehouse development for new Financial
Projects catering to the high Availability needs as required. GEO-Sparse
Replication Monitoring and Management. ETL and Reporting were the Main
Focus of the Project using Crystal Reports and Informatica as an ETL
Platform.
TCS, India JAN 01 - JUNE 02
Data warehousing Consultant / DBA
Worked on all phases of data warehouse development lifecycle, from
gathering business requirements to Development, testing, implementation,
and support. Exceptional background in analysis, design, development,
customization, and implementation and testing of software applications and
products. Demonstrated expertise utilizing ETL tools, including, Data
Transformation Services (DTS), and Data Stage and ETL package design, and
RDBM systems like SQL Servers, Oracle, and DB2. Experience training
developers and advising technical groups on ETL best practices.
HCL Info Systems Ltd, India MAY 1998 - DEC 2000
Database Developer / DBA / C++
Defining and Implementing Raid Level's with 120 PC Network Farm. Studying
the Business Environment for this Project was the Main Crux. The Project
was designed with different ERP implementations. (Inventory Control /
Production Planning / Purchasing / Sales / Market IN / Financial / HR).
Develop Triggers and Procedures in SQL server 7.0 and PL-SQL in oracle 7.0
Develop ad-hoc Queries. Design and Maintain Indexing Strategy. Performance
Tuning of Database systems. Develop various API's and DLLS for Project
Integrations.
PCL Mindware, Bangalore India NOV 1997 - FEB 1998
C++ Developer / SQL Server Developer
The System automated the ordering process of locomotive and other heavy
Engineering products. Responsible for Study, Design, Development, Testing,
Implementation, and Maintenance of the system and application software.
Involved in Database design, and administration. Developed under Windows NT
4.0 using SQL Server RDBMA ver 6.5 and 6.0 and utilities like ISQL-W.
Software Mart India Limited India JULY 1995 - NOV 1997
Software Developer/Database Testing
Involved in Design and Development of project. Developed a single output
structure for various departments. Training of the user departments.
Rest Assured.
Contact this candidate