We provide IT Staff Augmentation Services!

Sr Sql Server Dba Resume

NJ

SUMMARY

A Microsoft Certified Database Administrator with 16+ years of strong expertise in OLTP, OLAP databases, ETL, enterprise data modeling, database tuning, data cleansing, data management, production support, data profiling, data migrations, stored procedures, replications, backups, disaster recovery planning, front-end interface design, server installations, configuration, and implementation.Experience and understanding of Data Warehousing, Data Integration, Master Data Management (MDM), Business Intelligence Reporting. A team player with strong leadership skills and ability to mentor junior level staff. Exceptional technical and analytical skills with the ability to communicate with all levels of corporate personnel. Industry experience includes Financial Services and State and Federal Government. Knowledge of Oracle, DB2 and Sybase databasesSoftware Life Cycle Expertise: Agile Methodology ,Full ETL Life Cycle, Business Process Analysis, Re-Engineering, Gathering System Requirements and Definition, Module Design, Development, Implementation, Production Migration, Integrated Testing and Post Support.

TECHNICAL SKILLS

DATABASE:

MS-SQL Server 6.5/7.0/2000/2005 , SQL LiteSpeed, Red-gate Tools, SQL Server Management Studio(SSMS), Enterprise Manager, Query analyzer, DTS, BCP, DBCC, Backing up and restoring, Scripts, MSDTC, PERFMON, SQL Performance tuning, IIS 4.0, Windows NT 4.0 Server, Windows 2000/2003,UDB DB2, ORACLE, Toad.

DATA WAREHOUSE TOOLS

INFORMATICA, BIDS, ETL, SSIS, Microsoft Analysis Services, Informatica, First Logic.

MODELING TOOLS

ERWin, Power Designer, MS-VISIO.

LANGUAGES

T-SQL, HTML, DHTML,SQL, PL/SQL, XML, COBOL, ASP.NET

INTERNET

ASP,ASP.NET,HTML,DHTML,VBScript,JavaScript,PERL,IIS5.0/6.0, .NET Framework, UML, COM+, FTP Component One Suite.

OPERATING SYSTEMS

Windows 95/98/00/NT/2003/XP, UNIX, MS-DOS , MVS

REPORTING TOOLS

SQLServer 2000 Reporting Services(SSRS),Crystal Reports 8.0/8.5/9.0, Business Objects, Cognos, OBIEE

GUI TOOLS

ASP.NET, VB5.0/6.0, VB.NET,VSS6.0, ,VisualStudio .NET

DATA ACCESS METHODS

ADO, DAO, RDO and ADO and OLEDB, ADO.NET

PROFESSIONAL EXPERIENCE

Confidential

My Contributions:

  • Worked as a Sr DBA for Capital Finance Department, responsible for multiple SQL Server cluster Instances, backup/restore, capacity planning, Disaster Recovery, High availability, Patching, supporting developers, maintaining data loads, deploying SSIS packages, monitoring, enhancing SSIS packages, deploying SSRS, reviewing stored procedures, performance and tuning of slow queries, analyzing locking and blocking issues
  • Performed SQL Server Compliance and fixing risk items, gathered and provided information to auditor’s requests to comply with the well forgo policy works. Used SQL Secure and Policy Based Management tools to gather information.
  • Monitored all production SQL Servers for Performance issues using SQL Sentry, Generated monthly reports to development groups to review and improve performance of stored procedures and functions.
  • Involved in preparing Standard Operating Procedures (SOP) documents, Build Documents for SQL Server.
  • Worked as Informatica Administrator to provide support to Data Warehousing and Integration team. Installed CRM and CDC Real-time components for Informatica powercenter.
  • Involved in Business Continuity Planning & Testing, tests include failover and failback of database mirroring.
  • Used SQL LiteSpeed for SQL Backups and restores, ERWin for maintaining schemas and RedGate tools for sql server related tasks.
  • Involved in planning, migration and building of 250 database servers from capital finance datacenter to wellsfargo data centers. Provided On Call 24X7 production support for 250+ Databases Servers.

Confidential

My Contributions:

  • Working as an Agile Sr SQL Server DBA for mission critical databases for Capital Finance supporting department.
  • Conducted SQL server compliance checks, health checks, data flows and performance issues.
  • Provided support to dev, qa, uat and production database environments and SSRS reporting environments.
  • Working with Agile developers conducting database code reviews, sql tuning.
  • Worked as a SQL Server Database Administrator for Enterprise Data Management group.
  • Responsible for 30+ SQL Servers, Backup/Restore, Capacity Planning, Supporting Developers, Maintaining Data Loads, Deploying SSIS Packages, Monitoring, Enhancing SSIS packages, database coding, reviewing stored procedures, Performance and tuning of slow queries, analyzing locking and blocking issues.
  • Installed EDM compliance software DBSmart, generating compliance reports, fixed failed items. Enabled SCOM monitoring software to send thresholds alerts on sql server as well as server.
  • Upgraded SQL Servers, Installed service packs, hot fixes to all servers. Standardized backup maintenance plans across all servers as per EDM Policies.
  • Configured Log shipping and mirroring as a part of disaster recovery plan. Supported database applications on Clustered, Shared and Virtual server environments.
  • Performed change management using BMC Remedy for DEV, QA, PROD deployments. Conducted Failover disaster recovery simulations for SSRS deployments.
  • Provided On Call 24X7 production support for 500+ Production Databases.

Environment:SQL Server 2012 /SQL Server 2008 R2/2005/2000, SSRS, SSIS,BMC REMEDY, DBSMART, SQL LiteSpeed, SCOM, SQL LiteSpeed, Redgate SQL Compare, Data Compare, SQL Sentry, SQL Secure, Informatica 9.5.1

Confidential

My Contributions:

  • Worked as a Sr DBA for Loan Processing Department, responsible for multiple SQL Server cluster Instances, backup/restore, capacity planning, supporting developers, maintaining data loads, deploying SSIS packages, monitoring, enhancing SSIS packages, Migrating DTS packages to SSIS packages, database coding, reviewing stored procedures, performance and tuning of slow queries, analyzing locking and blocking issues
  • Created complex SSIS packages to perform Near Real–time ETL to load data to model every 15 min.
  • Created data workflows timeline diagrams based on requirements to analyze and conducted verification for data standardization. Used TFS to prepare deployment scripts to QA/PROD database servers.
  • Involved in design, developing and implementation of Logging, exception reports and error logs.
  • Created physical database objects like databases, tables, stored procedure, view, trigger, query and, users/login. Create database dictionary with Meta data information. Did performance analysis for stored procedure and reporting queries
  • Developed reports using SSRS & OBIEE and also create data model for users to generate ad-hoc reports. Maintained OLAP and OLTP database models using ERWin.

Environment:SQL Server 2005/2008 R2, SSIS2005/2008, SSRS, OBIEE, DTS, TFS

Confidential

My Contributions:

  • Worked as a Sr SQL Server Database Administrator, responsible for multiple SQL Server Instances, Backup/Restore, Capacity Planning, Supporting Developers, Maintaining Data Loads, Deploying SSIS Packages, Monitoring, Enhancing SSIS packages, database coding, reviewing stored procedures, Performance and tuning of slow queries, analyzing locking and blocking issues.
  • Lead the legacy mainframe data migration/conversion to SQL Server 2008 data warehouse/data mart for their business intelligence project. Documented the legacy data keys and relationships using ERWIn modeling tool.
  • Successfully Implemented IBM Optim, Auttunity suite & Oracle to ETL data from legacy mainframe system to SQL Server 2008. Migrated IBM UDB DB2 tables, IMS databases, VSAM files and Flat Files to to SQL Server 2008 tables. Migrated more than 1 billion records from legacy mainframe patient billing data to optim compressed archive files and restored those archive files to SQL Server 20008.
  • Documented Installation of software, Standard Operating Procedures.

Environment:IBM Optim 7.2, Auttunity Suite, IBM UDB DB2, Oracle HSODBC, IMS, VSAM, SQL Server 2008, SSRS, ETL, Windows 2003 Server, ERWin7.2.

Confidential

SR SQL Server DBA

My Contributions:

  • Worked as a Sr SQL Server Database Administrator, responsible for multiple SQL Server Instances, Backup/Restore, Capacity Planning, Supporting Developers, Maintaining Data Loads, Deploying SSIS Packages, Monitoring, Enhancing SSIS packages, database coding, reviewing stored procedures, Performance and tuning of slow queries, analyzing locking and blocking issues.
  • Worked as a Sr DBA Responsible for multiple projects involving design, analysis and database build deployments for Dev, QA and Production environments. Responsible for deploying SSIS Packages.
  • Successfully implemented 16 log-shipping databases for the LOB.
  • Migrated SQL Server 2000 database to SQL Server 2005.
  • Installed SQL Server Software builds, Patches on SAN clusters.
  • Responsible for 11TB BI database system on 64TB CLUSTERED SAN.
  • Conducted SQL Server Health Check and present the report to line of business with best practices, standards & facts.
  • Responsible for tuning and resolving performance Issues on multiple VLDB database, using SQL Server Profiler and Perfmon tools.
  • Worked on database Backup/Restore using SQL Server Native and Light Speed, Capacity Planning, Log Shipping, Supporting Developers
  • Performed Database BUILD Deployments using ECM Process Worked with IT Operations team regarding space issues, sql server dumps and IO problems for High Volume Transaction System.
  • Designed, Developed SSIS packages for Client ETL need. Worked with different source feeds like ORACLE, FLATFILES and SQL SERVER. Mentored application developers to teach SSIS development skills. Migrated DTS packages to SSIS packages.

Confidential

My Contributions:

  • Worked as a Sr SQL Server Database Administrator, responsible for multiple SQL Server Instances, Backup/Restore, Capacity Planning, Supporting Developers, Maintaining Data Loads, Deploying SSIS Packages, Monitoring, Enhancing SSIS packages, database coding, reviewing stored procedures, Performance and tuning of slow queries, analyzing locking and blocking issues.
  • Worked as a Sr DBA Responsible for multiple projects involving design, analysis and database build deployments for Dev, QA and Production environments. Responsible for deploying SSIS Packages.
  • Prepared Detail Database Design documents using WCS Application Use Case Requirement documents.
  • Worked with Data Architect and Project Manager on Level of Estimates for the project tasks.
  • Worked as an ETL Architect/Sr ETL Developer/Modeler to design, develop and Implement Full Data warehousing ETL Life Cycle starting from creating Data Mart Model, ETL Data Flows, SSIS packages, SSIS Package Configurations, Error Log Process, Auditing engine rules, Deployments and Support.
  • Implemented Model Driven Architecture (MDA). Created and Maintained Physical and Logical models. Generated T-SQL Scripts from the Modeling tool for QA and PRODUCTION database deployments. Responsible for maintaining the Data warehousing models in PoweDesigner.
  • Involved in conducting “Data Analysis “for all subject areas in building the data mart.
  • Developed complex stored procedures to calculate Business Minutes, Calendar Minutes and covenant Calculation dates.
  • Developed SSIS Packages using Microsoft SQL Server Integration Services Designer. Resolved error that occurred while deploying SSIS packages built on 32 Bit Development workstation and deployed to 64 Bit Processor Server Environments. Involved in performance tuning SSIS packages.
  • Implemented Kimball Methodologies building the Data Mart.
  • Worked with Project Data Architect Reviewing the ETL data flows, Auditing, Error logic process, slowly changing Data process logic (SCD).
  • Worked with Business Objects Reporting team and QA team to coordinate and resolve any ETL Data issues.
  • Implemented Database Mail component on SQL Server 2005 to broadcast ETL Status information to an email distribution list.

Environment:SQL Server 2000/2005, BIDS(Business Intelligence Development Studio), Team Foundation Server 2005(TFS 2005), Microsoft Visual Studio 2005/2008, T-SQL, SSIS, Power Designer 11, Business Objects, AIX, SSAS, ETL, ASP.NET, Windows 2003 Server.

Confidential

Data Architect/DBA/ETL Developer

My Contributions:

  • Architected and developed a data warehousing project for the client.
  • Lead a team of 8 people compromised of DBA, Business Analyst, ETL Architect, ETL Developers, and Data Analyst. Conducted technical interviews to hired DBA, ETL Developers to build a data Integration/warehousing team for this client.
  • Conducted business process meeting with business users to document the existing business process flows.
  • Worked as a Sr SQL Server Database Administrator, responsible for SQL Server Installations, Applying Patches, Backup/Restore, Capacity Planning, Supporting Developers, Maintaining Data Loads, Deploying SSIS Packages, Monitoring, Enhancing SSIS packages, database coding, reviewing stored procedures, Performance and tuning of slow queries, analyzing locking and blocking issues on Cluster Environments.
  • Used SSIS for RAD ETL development using SSIS packages to Import data from different format of source files originating from SXC. Designed and Implemented Scrubbing logic to maintain Data Quality. Worked on SSIS Export Process to send data to CMS (Center for Medicare & Medicaid Services).
  • Designed Developed & Implemented SSIS auditing template as the baseline template for SSIS development. Trained junior developers in developing SSIS packages. Trained Jr DBA in ERWin Modelling Technique.
  • Worked with DBA, Directors & project managers to design & implement data integration environment.
  • Migrated DTS packages to SSIS packages, Developed, QA & Implemented SSIS package to ETL data into SQL Server 2005 tables.
  • Worked & Supported ETL Developers, Business Users to review stored procedures.
  • Implemented Erwin Data Modeler 7.2, Worked with data modelers to validate and maintain models for EDW. Recommended ERWin for EDW data modeling. Developed ERWin database modeling standards
  • Prepare standard operating procedures for Installing SQL Server, Maintenance Plan, and Back up Recovery.

Environment:SQL Server 2000/2005, T-SQL, SSIS, SSRS, SSAS, ETL, ASP.NET, Windows 2003 Server, ERWin7.2,

RedGate Suite.

Confidential

Sr DBA/Data Modeler

My Contributions: OCT 2006 – MAY 2007.

  • Working as a Sr SQL Server Database Administrator for Production, Development & QA team responsible for SQL Server Installations, Applying Patches, Backup/Restore, Capacity Planning, Supporting Developers, Maintaining Data Loads, Monitoring, Enhancing DTS packages, database coding, reviewing stored procedures, Performance and tuning of slow queries, analyzing locking and blocking issues on Cluster Environments.
  • Created and modified DTS packages to ETL data from Mainframe export files to SQL Server and SQL server database to Seibel application. Worked on data staging and data cleansing Issues.
  • Supported various income tax related projects involving ASP.NET, Seibel Call Center, FileNet, SQL Reporting services (SSRS) and Mainframe applications. Followed Agile Development Methodology including daily SCRUM meetings and STORM support for databases.
  • Worked with developers, Business Users to review stored procedures, schemas adhering to R.I.T.A database standards.
  • Used Erwin, conducted logical and physical data model walk-through and design review, generated QA and Production release scripts. Implemented Model Driven Architecture. Worked with Developers, Business Analysts to update the ERWin Models.
  • Prepare standard operating procedures for Installing SQL Server, Maintenance Plan, and Back up Recovery.
  • Implemented SQL Server 2005 in test and QA environments. 24x7 on call support for all database environments including Oracle databases.

Environment:SQL Server 2000/2005, T-SQL, ETL, ASP.NET, Windows 2003 Server, VSS6.0, SQL Reporting Services, UML, DHTML, ER Win, Seibel Call Center, File Net Document Management System.

Confidential

Sr DBA/Developer

My Contributions: JULY 2006 – SEP 2006

  • Worked as a Sr SQL Server Database Administrator for Production, Development & QA team responsible for SQL Server Installations, Applying Patches, Backup/Restore using SQL Lite Speed, Capacity Planning, Supporting Developers, Maintaining Data Loads, Replication, Monitoring, Enhancing DTS packages, database coding, reviewing stored procedures, setting up and monitoring SQL Server Replication, Performance and tuning of slow queries, analyzing locking and blocking issues.
  • Worked on various web, ERP application involving ASP.NET, Seibel, Great Plains, Hyperion application and ORACLE databases.
  • Worked with developers, EDW team, Business Users to review stored procedures, schemas adhering to CEB database standards.
  • Used Erwin 4.1, Model Mart for creating Enterprise Data Models Specs. Conducted logical and physical data model walk-through and other design review
  • Prepare standard operating procedures for Installing SQL Server, Maintenance Plan, and Back up Recovery.
  • Created DTS packages to ETL data from Seibel to SQL server database web applications.
  • Hands on experience installing SQL2005, creating DML release scripts for QA, DEV, PROD environments. Wrote VB.Net program to process log files and update ORACEL tables.

Environment:SQL Server 2000/2005, SAN CLUSTER, T-SQL, ETL,ASP.NET, Windows 2000/2003 Server, VSS6.0, SQL Reporting Services, ER Win, Business Objects, Hyperion.

Confidential

Sr DBA/Developer

My Contributions:

  • Worked as a Senior SQL Server Database Administrator for the Development and QA team working on a project basis. Projects have encompassed systems to account for the following: contract/contact information; gift tracking/accounting and conference scheduling. Responsibilities include: the use of ERWin 4.1 Model Mart to create enterprise data model specifications; logical and physical data model walk-through and reviews; SQL Server installation, applying patches, backup/restore using SQL Lite Speed, capacity planning, performance tuning, supporting developers, maintaining data loads, replication, monitoring, enhancing DTS packages, database coding, stored procedures, setting up and monitoring SQL Server replication etc.
  • Worked closely with developer team and business analysts. Conducted peer review of code.
  • Extensively used Red-Gate tools like Data Compare, SQL Compare and SQL Packager for deployment.
  • Evaluated & Installed SOX/database auditing software’s like Guardium and DBAudit.
  • Member of a daily on-call support team.

Environment:SQL Server 2000/2005, T-SQL, DTS, SQL Lite Speed, SQL Red-Gate tools, Windows 2003 Server, VSS6.0, ASP.NET, ER Win, SAN .

Confidential

SR DBA/Data modeler

My Contributions:

  • Functioned as a Sr DBA for the data management group performing capacity planning, performance tuning, supporting developers, maintaining data loads, replication, database monitoring and DTS packages enhancements.
  • Used Erwin 4.1, Model Mart for creating enterprise data models specs. Conducted logical and physical data model walk-through and other design review.
  • Responsible for 10 SQL Servers with more than 45 databases with sizes ranging from a GB to Terabytes. Working in a SQL Cluster environment on an IBM SAN with responsibility for production and development as well as staging and data warehouse databases.
  • Responsible for monitoring mission critical DTS data loads for Line of Business including Campaign Loads, Remails, Avaya Dialer loads and Referral Loads. Involved in converting slow running DTS packages to Informatica processes to increase data load performance.
  • Prepared requirements documentation for multiple projects including marketing, accounting and IT. Supported and worked on Change Requests for production servers.
  • Created source to target mapping docs and process flows diagrams
  • Designed, implemented and documented DTS packages to ETL data for staging databases.
  • Involved in gathering requirements from marketing division and implementing the business logic as a DTS/stored procedure.
  • Involved in daily on-call support for all data management production databases.
  • Documented SOP for all maintaining tasks and upcoming projects.
  • Created, Configured and Maintained Data Repositories in Oracle for Data warehousing Project. Responsible for maintaining BO universe.
  • Created Source to Target mapping docs, process flows diagrams
  • Prepared Meta Data Repositories for Informatica process. Responsible for maintain BO universe Residing in Oracle database.

Environment:SQL Server 7.0/2000, IBM SAN, T-SQL, ETL,ASP, JavaScript, ADO, IIS6.0, Windows 2000 Server, VSS6.0, SQL Reporting Services, UML, DHTML, ASP.NET, ER Win, Business Objects, Informatica, First Logic.

Confidential

DBA/Developer

My Contributions:

  • Participated in internal projects for Regentsystems and performed work for external clients including SQL Server design and development as well as database administration.
  • Used S-Designer to Model Enterprise Database Architecture for HR, Accounting, Invoicing, and Payroll applications.
  • Data Warehousing/Analysis Services/OLAP: Responsible for developing a data warehouse for Business Intelligence and other analysis using SQL Server, DTS & Analysis Services (OLAP server). Gathered requirements from the users and designed the data marts and reports. Installed configured SQL reporting services to generate corporate reports.
  • Implemented a data warehouse solution using Kimball's methodology and has experience in managing full life cycle development of large data warehouse/data mart projects and participating in enterprise data warehouse architecture plans. Extensively used Informatica, BO reports for ETL, developed data translation maps and mapplets. Installed and configured Informatica repository for Oracle 9i database.
  • Identified and gathered product requirements to create a centralized Enterprise SQL Server database to handle corporate data residing in multiple MS Access databases.
  • Designed SQL Server 2000 database to generate statistical data for DOJ status reports.
  • Responsible for database coding and stored procedures, setup and monitored SQL Server replication, provided performance tuning of slow queries, analyzed locking and blocking issues in the production environment.
  • Served as a mentor for all other employees and contractors by assisting them on numerous SQL Server related tasks.
  • Everyday duties included: the set-up of new SQL Servers and copying production databases for system, unit and acceptance testing. This required extensive knowledge of data and object migration tools such as DTS. Other tasks included: the upgrade, installation, creation, management and integration of databases, the continuous enhancement of backup and restoration plans and monitoring and troubleshooting.
  • Designed and developed bison license, Cardking software application packages using VB6, VB.NET, ASP, ASP.NET technologies.
  • Hands on experience in Administering, Installation and Configuring Windows NT networking, Domain Servers, Applications Servers and Database Servers.
  • Provided production support for mission critical data translation effort (ETL) for DAAS which monitors data between all navy, air force and defense bases in USA for 2 years.

Confidential

SQL Developer

My Contributions:

  • Installed, administered production and development SQL Server databases.
  • Designed and developed triggers and stored procedures in SQL Server 7.0.
  • Handled issues with SQL Server stored procedures.
  • Provided ETL data to SQL Server table’s quarterly using DTS packages.
  • Production support and maintenance of an online catalog in SQL Server 7.0.
  • Provided production support for the web site and the handling of required content changes in English and French. Implemented Transactional SQL Replication.

Environment:WIN NT Server, Microsoft SQL Server 7.0, ASP, VB Script, PERL, CGI.

Confidential

QA Analyst/Developer

My Contributions:

  • Developed, implemented, and maintained databases for a wide variety of budget application used for 16 departments at the Ohio Department of Insurance.
  • Data was downloaded from the CAS (Central Accounting system) FTP site, used DTS to import text files into the SQL Server 6.5 tables, and then apply business and financial rules.
  • Installed Oracle 7.3/8.0 and migrated MS Access 97 to Oracle 8.0 DB and created DB tables.
  • Re-wrote a billing report application that is used by ODI to create invoices. Four forms and six reports were generated to meet user requirements using Crystal Reports and VB.
  • Used Visio Professional to implement a re-design of the ODI Application System Topology that identifies all applications and their interfaces.

Environment: WIN NT, SQL Server 6.5/7.0, DB2, Oracel8.0

Confidential

QA Tester

  • Member of a technical team responsible for Y2K compliance of banking applications.

Environment:WIN NT, OS2, MVS, DB2, COBAL, WANG.

Hire Now