Sql Server Data
Resume:
E Bader Cheema
Centreville, VA 20120
Phone: 703-***-****
Email: ***********@*****.***
SUMMARY:
Overall 14+ years of experience in MS-SQL Server and Oracle Administration including Design and implementation of Distributed/Replicated Databases, planning/implementing backup/recovery strategies, Disk space management, Memory management and Performance tuning.
Extensive experience in ETL process by using SSIS (SQL Server Integration Services) and DTS Designer in SQL Server and Oracle environments and creating reports using SSRS (SQL Server Reporting Services)
Experienced in comparing schemas in different databases using Red Gate software
Experience in monitoring and tuning multiple databases SQL Server and Oracle databases using MS-SQL server Administration tools (MMC) and Oracle Enterprise Manager
Experienced in setting up Microsoft Cluster and managing SQL Server 2005/2008/2012 databases in Cluster environment
Experience in SQL Server stored procedures, views, triggers, UDF’s and configuration of multiple instances, and clusters
Involved in design and development of SSIS/DTS packages to load data from Oracle, Excel, Access and flat file feeds to SQL Server and vice versa
Involved in performance tuning of very complex SQL statements and procedures using showplan and iostatic, creating named cache and binding objects
Expertise in trouble-shooting (handling database corruption, transaction log problems, deadlocks, and Query performance problems)
Expert in performing database consistency checks (DBCC Commands) and planning and scheduling Backup & Recovery
Expert in MS SQL Server 2005/2008/2012 Administration, which includes Installation & Configuration on Windows 2000/2003/2008 Server
Expert in Oracle Administration, which includes Installation & Configuration of Oracle database in stand-alone and RAC environment
Experienced in creating ASM instance and migrating from OCF2 to ASM on Oracle 10g/11g
Designed High Availability Databases with Oracle Standby Database, RAC
Expert in Disaster recovery using RMAN and GALAXY Backup Systems
Microsoft Certified IT Professional (MCIT DBA) SQL Server 2008/2005
Microsoft Technical Solution Expert (MSTS) SQL Server 2005
Oracle Certified Professional (OCP) DBA
Oracle Certified Professional (Managing Oracle on Linux Certified Expert)
TECHNICAL EXPERTISE:
O/S: DOS 6.1, Windows XP/2000/2003, HP UNIX, Linux Red Hat Enterprise
Hardware: IBM PC/AT 486, Pentium, Pentium II & III
Languages: SQL, PL/SQL, HTML, DHTML, JAVA Script, VB Script, Visual Basic 6.0, Computer Graphics with OpenGL
Applications: Office 2003/2007, FTP, XML, TCP/IP
Tools: RMAN, Oracle Enterprise Manager, Visio, ERwin 3.52, Quest TOAD, Quest Schema Manager, Import & Export, Spotlight, SQL Lab Vision, ASMCMD, SQL Server Migration Assistant (SSMA 4.0)
SQL Backtrack (BMC Software), DB Artisan, SQL*Loader, Reporting Services (SSRS), Red Gate, SharePoint 2007/2010, Power Shell Scripting
RDBMS: MS SQL Server (2014, 2012, 2008R2, 2008, 2005, 2000, 7.0, 6.5), Oracle 10g/9i/8i/8, MS Access 2000/2003
Work Experience:
Alltech International, Inc
September 2012 – Current
As a Senior Database Architect Consultant, responsible to work with Northrop Grumman’s CI Data Analytics Team (CIDA) for the Criminal Investigation (CI) Division of IRS to assess the existing database architecture running on SQL Server 2005 and give recommendations how to improve existing database performance or move to Oracle 11g.
Place: Washington, DC
Database Version: SQL Server 2005/2008/2012/2014, Oracle 10/11g
As a Senior DBA Architect, my responsibilities included:
Prepares system requirements, source data analysis and process analyses documentation and design documentation throughout the database creation and implementation
Identifies improvement and technological solutions for decision support services, data analytics services and data management system enhancements
Investigates and evaluates new data analytics algorithms and technologies to support investigative data analysis requirements
Follows processes and procedures to identify and implement process improvements
Participates in and conducts data extraction, transformation and load code, preprocessing and post processing scripts peer reviews
Effectively and actively communicates with the engineering team, management, and the IRS Customer
Setup database mirroring using Always On (AG) feature of SQL Server 2012
Computer Sciences Corporation (CSC)
May 2012 – September 2012
As a Senior Database Administrator, responsible for analysis, design, implementation, tuning, and maintenance of logical and physical databases based on business requirements.
Place: Springfield, VA
Database Version: SQL Server 2005/2008/2008 R2/2012/2014
As a Senior DBA Developer, my responsibilities included:
Analyze and define the logical and physical database structure on the project requirements
Establish, maintain, and control the project data model and data dictionary
Provide technical guidance to system and application programmers
Develop, document, and enforce standards, security procedures and controls for access to ensure the integrity of database system
Design, implement, and periodically test the backup and recovery procedures
Direct and participate in the conceptual database design and specifications
Perform database administration activities including but not limited to installation, configuration, backup and maintenance of the databases in multiple environments
Perform database tuning activities using different approaches such as reviewing indexing strategies, database and server configurations
Perform database tuning activities using different approaches such as reviewing indexing strategies, database and server configurations
Ensure the reliability, serviceability, and maintainability of the system with demonstrable accuracy, privacy, and security
Develop test plans and test data for database systems and support software.
Serve as a primary point of contact for hardware, software and database upgrades, removing and servicing user accounts on system platform and in all databases
Contribute in the development knowledge base
Participate and contribute in process improvement activities at the project and corporate level
Bureau Of Indian Affairs (BIA) - Consultant
February 2011 – April 2012
As a Senior DBA Consultant, responsible to design, implement and manage SQL Server 2005/2008 databases. Responsible for analysis, design, implementation, tuning, and maintenance of logical and physical databases based on business requirements.
Place: Herndon, VA
Database Version: SQL Server 2005/2008/2008 R2/2012/2014
As a Senior DBA Consultant, my responsibilities included:
Responsible to design and implement SQL 2005/2008/2008-R2 Servers running on 64-bit windows servers in cluster environment in DEV, Testing, and PROD
Responsible to manage SQL Server 2008-R2 databases for SharePoint 2007/2010 environment
Responsible to optimize SharePoint 2007/2010 databases for better performance
Interact with system administrators to allocate storage for SharePoint databases
Familiar with SharePoint 2007/2010 site creation, manage user permissions, SharePoint Central Administrator tool
Responsible to configure different SharePoint 2010 services and creation of SharePoint databases
Helped migration/upgrade SharePoint from 2007 to 2010
Interact with users to gather business requirements and build solutions based on SQL Server technologies
Responsible to review code (stored procedures, functions, etc), approve and move into Production environment
Responsible to review database log files to identify risks and issues. Escalate risks and issues to management and recommend solutions
Follow pre-defined SDLC process
Responsible to enforce database standards for coding (stored procedures, functions, triggers etc)
Responsible to create and maintain complex SSIS/DTS packages
Involved in taking BACKUPS and restoring process of Development, Testing and Production Databases
Involve in creating Disaster Recovery process for SQL Server 2005/2008
Involve in creating database mirroring for disaster recovery process and maximum uptime for SQL Server 2005/2008 databases
Experienced on creating, migrating, and upgrading DTS packages from SQL 2000 to SQL 2005 SSIS/DTS packages
Involved in doing Capacity planning for business critical applications running on SQL Server 2005
Build a process to load data using DTS and SSIS packages
Responsible to install SQL Server software and apply patches/service packs as needed
Managing and scheduling daily jobs relating to data transfers, backup and recovery, transaction log dumps on SQL Server
Responsible for implementation and administration of SQL Server Databases for maximum uptime
Government Accountability Office (GAO) - Consultant
May 10 – February 2011
As a DBA Consultant/Architect, responsible to design and implement SQL Server Enterprise platform to manage E-Mail messaging system using Archive Manager and Blackberry Enterprise System (BES) applications.
Place: Washington, DC
Database Version: SQL Server 2005/2008
As a Senior DBA Consultant, my responsibilities included:
Responsible to design and implement SQL 2005 Servers running on 64-bit windows servers in cluster environment in DEV, Testing, and PROD
Involve in creating Disaster Recovery process for SQL Server 2005
Experienced in migrating Oracle database to SQL Server 2005 using SSMA 4.0 tool
After mapping schemas (from Oracle to SQL Server), install SQL Server and create databases based on schema requirements
Worked with developers to map the objects from Oracle to SQL Server 2005 migration
Involve in creating database mirroring for disaster recovery process and maximum uptime for SQL Server 2005 databases
Experienced on creating, migrating, and upgrading DTS packages from SQL 2000 to SQL 2005 SSIS packages
Involved in doing Capacity planning for business critical applications running on SQL Server 2005
Build a process to load data using DTS and SSIS packages
Build reports using SQL Server Reporting Services 2005 (SSRS)
Involved in taking BACKUPS and restoring process of Development, Testing and Production Databases
Responsible to install SQL Server software and apply patches/service packs as needed
Managing and scheduling daily jobs relating to data transfers, backup and recovery, transaction log dumps on SQL Server
Responsible for implementation and administration of SQL Server Databases for maximum uptime
Provide 24 hours on-call support for SQL Server databases
Housing Urban Development (HUD) - Consultant
Dec 09 – May 2010
As a DBA consultant, responsible to create and manage 2 node SQL Server 2005 cluster to manage business critical application. Responsible for analysis, design, implementation, tuning, and maintenance of logical and physical databases based on business requirements and create a plan to consolidate the SQL Servers.
Place: Washington, DC
Database Version: SQL Server 2005
As a Senior DBA Consultant, my responsibilities included:
Responsible to manage SQL 2005 Servers running on 64-bit windows servers in cluster environment in DEV, Testing, and PROD
Involve in creating Disaster Recovery process for SQL Server 2005
Involve in creating database mirroring for disaster recovery process and maximum uptime for SQL Server 2005 databases
Experienced on creating, migrating, and upgrading DTS packages from SQL 2000 to SQL 2005 SSIS packages
Experienced in managing SQL Server databases in Cluster environment
Involved in doing Capacity planning for business critical applications running on SQL Server 2005
Build table partitioning for big tables to improve performance
Build a process to load data using DTS and SSIS packages
Build reports using SQL Server Reporting Services 2005 (SSRS)
Normalization, data modeling, data transformations, mapping, and data mining
Involved in taking BACKUPS and restoring process of Development, Testing and Production Databases
Backup and restore databases utilizing maintenance plans, T-SQL, or third party tools BackupExec
Responsible to install SQL Server software and apply patches/service packs as needed
Responsible to work with business analysts, developers, and infrastructure technologies to meet the organizations goals
Prepare change control documents for each job/package developed for promoting from Test to QC, and to Production
Determine database movement strategies across servers using Red-Gate software
Help analyze performance issues on existing systems and aid developer to optimize stored procedures
Managing and scheduling daily jobs relating to data transfers, backup and recovery, transaction log dumps on SQL Server
Responsible for implementation and administration of SQL Server Databases for maximum uptime
Provide 24 hours on-call support for SQL Server databases
National Grange Mutual (NGM) Insurance Company
July 05 – Dec 09
As a functional DBA team lead, responsible to assign database related work to junior DBA’s and manage multiple database related projects. Also as a senior DBA, responsible to manage multiple databases running on SQL Server and Oracle platforms. Responsible for analysis, design, implementation, tuning, and maintenance of logical and physical databases based on business requirements.
Place: Jacksonville, FL
Role: Functional DBA Team Lead
Database Version: SQL Server 2005/2000, Oracle 10g
As a Senior DBA/Developer, my responsibilities included:
Responsible to manage SQL 2005 Servers running on 64-bit windows servers in cluster environment in DEV, QA, and PROD
Experienced enough migrating/upgrading SQL Server database from SQL 2000 to SQL 2005
Experienced in migrating Oracle database to SQL Server 2005 using SSMA 4.0 tool
Worked with developers to map the objects from Oracle to SQL Server 2005 migration
Experienced on migrating/upgrading DTS packages from SQL 2000 to SQL 2005 SSIS packages
Experienced in managing SQL Server databases in Cluster environment
Involved in doing Capacity planning for DW and other projects
Build table partitioning for big tables to improve performance
Build a process to load data to Data Warehouse using DTS and SSIS packages
Build reports using SQL Server Reporting Services 2005 (SSRS)
Normalization, data modeling, data transformations, mapping, and data mining
Involved in taking BACKUPS and restoring process of Development, QA and Production Databases
Backup and restore databases (size up to 1 TB) utilizing maintenance plans, T-SQL, or third party tools Commvault (similar to LiteSpeed)
Responsible to install SQL Server software and apply patches/service packs as needed
Responsible to work with business analysts, developers, and infrastructure technologies to meet the organizations goals
Prepare change control documents for each job/package developed for promoting from Test to QC, and to Production
Determine database movement strategies across servers using Red-Gate software
Reverse engineer to draft ERD of databases used by a third party application ERWIN/VISIO
Help analyze performance issues on existing systems and aid developer to optimize stored procedures
Manage database security including encryption, server/database logins and roles
Used SQL Profiler extensively to monitor the performance of the application/data migration and databases
Design, implement, and maintain Oracle and SQL Server Databases
Managing and scheduling daily jobs relating to data transfers, backup and recovery, transaction log dumps on both Oracle and SQL Server
Responsible for implementation and administration of SQL Server/Oracle Databases for maximum uptime
Involve in creating Disaster Recovery process for both SQL Server and Oracle databases
Involved in complex code reviews and code walkthroughs of various projects
Provide 24 hours on-call support for both SQL Server and Oracle production databases
Experienced in creating, implementing, and managing transparent data encryption in Oracle databases
Experienced in creating and managing Oracle databases on 2 node RAC environment
Experienced in creating and managing ASM instances in RAC and stand alone environments
Select Portfolio Servicing Inc May 05 – July 05
Responsible as a Databases Administrator to manage/create SQL Server databases and troubleshoot any production problems relating to databases and worked with developers to create application to support the loan processing process
Place: Salt Lake City, UT
Database Version: Microsoft SQL 7.0/2000/2005
DataCert Inc
June 04 – Apr 05
Responsible as a Sr. Data Architect/DBA to create/manage the data model and responsible to manage the production and development databases in SQL and Oracle.
Place: Houston, TX
Role: Data Modeler/DBA/Developer
Database Size: Max 100 GB’s
Database Version: Microsoft SQL Server 7.0/2000, Oracle 8i/9i
Lewis Computer Services
Mar 04 – June 04
Responsible as a SQL Server Developer/DBA Consultant to setup a Transaction Replication and then transfer the data back to the main database from different clients.
Place: Baton Rouge, LA
Role: SQL Server Developer/Database Administrator (DBA)
Database Size: 10 GB’s
Database Version: Microsoft SQL Server 7.0/2000
Aegis Mortgage Corporation
April 03 – Dec 03
Responsible as a member of DBA team to design, implement, and maintain SQL Server 6.5/7.0 2000 Databases on NT/2000 environment.
Place: Baton Rouge, LA
Role: SQL Server 2000 Database Designer/Administrator (DBA)
Database Size: 50 GB’s to 100 GB
Database Version: Microsoft SQL Server 7.0/2000
CMS Oil and Gas
Apr 01-Feb 03
Responsible as a member of DBA team to design, implement, and maintain large Oracle and SQL Server 2000 Databases on NT/2000 and HP UNIX environment.
Place: Houston, TX
Role: Oracle/SQL Server 2000 Database Administrator (DBA)
Database Size: 50 GB’s to 100 GB
Database Version: Oracle 7/8/8i, Microsoft SQL Server 7.0/2000
Education: Louisiana State University
Bachelor of Science in MIS (Management Information Systems)
University Of New Orleans
Bachelor of Science in Business Administration
Status: US Citizen
Contact this candidate