We provide IT Staff Augmentation Services!

Ms Sql Server Dba Resume

Wayne, NJ

Professional Experience Summary

  • 7+ Yrs of SQL Server DBA experience in Banking Government IT, Commercial, Government IT, Health and Finance environments
  • Expertise in Security Issues such as creating logins and granting permissions on various objects as well as Administering security for server’s logins regularly(Windows and SQL Accounts) and guest user logins.
  • Supports day to day operational duties for the database platform such as service requests and tickets, backups, monitoring, performance tuning, system troubleshooting, and other tasks as assigned or expected from DBAs
  • Experience working on SQL Server Reporting Services.
  • Authors and maintains operational documentation, best practices, and run books for the operational platform.
  • Comfortable understanding of Microsoft SQL Server database, theories, principles, and practices.
  • Experience in Migration from SQL Server 2005 to SQL Server 2008 as well as DTS Xchange tool involve migrating DTS packages to SSIS packages.
  • Has thorough knowledge of administrative and technical resources available and a demonstrated ability to use those resources for problem determination, product enhancements, and other technical issues related to theSQLServer components being administered
  • Possess good knowledge with experience in an operational environment providing support requiring coordination with release management and change management.
  • Good hands on working experience in SQL Server database administration and development performed with DBA duties all in enterprise environment.
  • Extensive experience with data modeling, Dimensional modeling, logical and physical database design.
  • Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, SQL Profiler, restoring full, differential, and log backups.
  • Great understanding and experience on Active Passive and Active Active Clustering model.
  • Maintained coding standards across the board in all SQL Server environments. Written and reviewed T-SQL code,
  • Worked extensively in OLTP & OLAP environments that included Production (24x7), QA and database development in SQL Server.
  • Good Knowledge in operating third party tools efficiently like TOAD, VERITAS Netbackup, LiteSpeed Pervasive ETL, SQL Assistant, ArcSDE, ERWIN, Visio 2007, Red-Gate and Spotlight.
  • Excellent T-SQL Programming skills, Execution Plan, query optimization & performance tuning. Used SQL Profiler, Performance Monitor and DBCC Commands.
  • Strong hold on report creation using Microsoft Reporting Services.
  • Application installation for database-centric applications like SAP and Siebel.
  • Experience in Replication Snapshot, Merge and Transactional.
  • Strong Knowledge in Performance tuning, database tuning techniques using monitoring tools like SQL Server profiler.
  • Extensively worked and excelled on Integration & Reporting Services and good experience in data migration from Oracle/Access/Excel Sheets to SQL Server 2008/2005/2000/7.0
  • Expertise with database backup and recovery procedures, disaster recovery solutions using log shipping and database mirroring and also high availability solutions like clustering and replication
  • Have sufficient experience using different Transformation tools like DTS packages, BCP, and BULKINSERT, SSIS.

Technical Expertise

Relational Databases

SQL Server 2008/2005/2000/7.0, MS-Access 2000/2003/2007, Oracle 9i & 10g, My SQL4/5.

Database Tools

SQL Server Enterprise Manager, Query Analyzer, SQL Profiler, SSIS, SSAS, SSRS, DTS, BCP, ODBC,SQL OLEDB, DBCC, ADO, ADO.NET, Business Intelligence Studio, Crystal Reports.

Languages

C, C++, C#, JAVA, VB.NET, ASP.NET, XML, PHP, UNIX Shell Scripts, T-SQL.

Operating Systems

Windows 2003, Windows 2000 server, Win ME/NT/XP, UNIX.

Web Servers

IIS 5.0/6.0, Apache, Tomcat.

Architecture

Relational DBMS, Client-Server Architecture, Clustering, Replication, OLAP, OLTP.

ETL

SSIS, DTS, Informatica, Data Stage.

Other Tools

Erwin 4.0/3.5, Microsoft Visual Studio 2003/2005, Service Center, MS Visual SourceSafe, Source Control, MS Visio, Windows System Monitor, Redgate ,sqlcompare, lite speed.

Education

  • Bachelors in Computer Science and Engineering

Certification

  • Microsoft Certified Technology Specialist (MCTS) in Microsoft SQL Server 2005
  • Microsoft Certified Professional (MCP)

Professional Experience:

Confidential, Wayne, NJ Jan 11 to till date
Role: MS SQL SERVER DBA

Responsibilities:

  • Involved in installing and configuring of SQL Server 2008.
  • Installed SQL 2008 standard edition with SP1 for testing present application and migrating test databases to test any upgrade issues.
  • Installed and configured ArcSDE layer for using ArcGIS applications like ArcMap, ArcView to work with SQL server by creating geodatabase repository in SQL server.
  • Supports day to day operational duties for the database platform such as service requests and tickets, backups, monitoring, performance tuning, system troubleshooting, and other tasks as assigned or expected from DBAs.
  • Establishing and maintaining custom-tailored backup/restore procedures and disaster recovery plans for Production Servers.
  • Performing daily backups for the geodatabases and also replicating geodatabases in an Enterprise environment.
  • Coordinating with the development team regarding tuning the SQL queries and stored procedures.
  • Responsible for all major database components of SQL Server and has strong knowledge of the various interrelationships between major system components including networking, storage, server, operating system, cluster, authentication, application code, and disaster recovery technology
  • Involved in Data modeling, designing and building relational databases using Erwin tool.
  • Has thorough knowledge of administrative and technical resources available and a demonstrated ability to use those resources for problem determination, product enhancements, and other technical issues related to the SQL Server components being administered
  • Configured Database Mirroring between primary server and a standby server.
  • Running DBCC consistency checks, and fixing data corruption in user databases.
  • Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
  • Creating databases and logins with permissions in SQL server 2008 as per the developer’s request.
  • Creating batch scripts for providing smooth solution to the ETL process.
  • Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008.
  • Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
  • Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups etc.
  • Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity.
  • Prepare daily report on the job failures, backup failures and disk space and implemented a e-mail notification solution to be notified when a threshold or error is encountered.
  • Involved in resolving dead lock issues and performance issues.
  • Configured and scheduled jobs to setup log shipping between production servers as well as standby servers.
  • Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
  • Developed a High level dashboard using SSRS 2008.
  • Created the logical and physical data modeling using Erwin tool.
  • Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
  • Extensive knowledge of performance optimization for both SQL Server configuration and SQL code tuning using OS performance monitors, wait and queue system DMVs, SQL Server statistics, index, and query plan DMVs, and vendor tools
  • Application installation for database-centric application like ArcSDE service used for GIS applications like ArcMap, ArcIMS and ArcCatalog.
  • Very good hands on experience with DBArtisan admin tool and SQL Assistant tool.
  • Identifying the bottlenecks and troubleshooting it for optimal performance.
  • Planned and Configured Transactional replication between Primary Server and three Read Only servers, with separate Distributor server and experience in troubleshooting replication problems.
  • Successfully Migrated SQL 2005 DTS packages to SSIS using DTS Xchange tool.
  • Additionally, designed and implemented a disaster recovery system.
  • Running Index tuning wizard and rebuilding indexes for faster query response.

Environment:
MS SQL Server 2008, Windows 2000/2003 servers, Active Directory ,IBEAM, ORACLE, ArcGIS server, ArcSDE, Pervasive ETL tool, Titanium Application, Outlook Express, IIS Web server, DTS, SQL Upgrade Advisor, MS Access, Microsoft Analysis Services, Diagnostic Manager, Microsoft Reporting Services, Microsoft SQL Server Integration Services(SSIS), SSRS, Litespeed, TOAD, DTS Xchange, Oracle APEX.

Confidential,New York May 09 to Dec 10
Role: Sr. MS SQL SERVER DBA

Responsibilities:

  • Involved in installing and configuring of SQL Server 2005 and 2008, both in unattended and remote installations.
  • Involved in Data modeling, designing and building relational databases.
  • Transferred data from Oracle to SQL server using SSIS.
  • Designed and tested (Unit, Integration and Regression) packages to extract, transform and load data using SQL Server Integration Services (SSIS).
  • Implemented Database Mirroring.
  • Running DBCC consistency checks, and fixing data corruption in user databases.
  • Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
  • Creating databases and logins with permissions in SQL server 2008 as per the developer’s request.
  • Creating Linked Servers between SQL server 2005/2008 and Oracle servers in the environment.
  • Making some server level changes for SSAS project.
  • Involving in migrating the backup jobs from SQLserver to Lite Speed
  • Monitoring backup jobs daily and run the jobs manually in case of failure depending upon the necessity.
  • Preparing daily report on the job failures, backup failures and disk space.
  • Involving in resolving dead lock issues and performance issues.
  • Creating and scheduling jobs to setup log shipping between production servers as well as standby servers.
  • Documenting daily tasks and scripting them using DBScribe.
  • Very good hands on experience with DBArtisan admin tool as well as VERITAS Netbackup.
  • Coordinating with the development team regarding tuning the SQL queries and stored procedures.
  • Identifying the bottlenecks and troubleshooting it for optimal performance.
  • Responsible for MS SQL Server 2008, configuration, tuning and provide 24 X 7 dedicated support to all Production, development and clustered servers.
  • Performing all aspects of database administration, including data modeling, backups andrecovery.
  • Configured Transactional replication between Primary Server and three Read Only servers, with separate Distributor server and experience in troubleshooting replication problems.
  • Resolved the SQL Server 2008 upgrade hurdles and successfully Migrated SQL 2005 DTS packages to SSIS using Upgrade advisor and Package Migration wizard.
  • Developed Query for generating drill down reports in SSRS 2008.Prepared AD HOC reports through report builders.
  • For complex packages like password protected packages, packages created using SQL Native client used DTS Xchange tool.
  • Additionally, designed and implemented a disaster recovery system.
  • Running Index tuning wizard and rebuilding indexes for faster query response.
  • Assigning permission to user(s), role(s), and object. Support column level permission. Administrate security for server’s logins (Windows and SQL Accounts).
  • Preparing Estimates for Database, table size growth.
  • Creating documentation to install SQL Server, apply service pack, hot fix and clustering installation.
  • Expertise in Security Issues such as creation and granting permissions on various Objects.
  • Preparing the reports for the day-to-day as well as weekly/monthly purposes.
  • Writing and integrating Stored Procedures to generate the Reports.


Environment:
MS SQL Server 2005/2008, Windows 2000/2003 servers, Active Directory ,ISA 2004, Outlook Express, IIS Web server, DTS, SQL Upgrade Advisor, MS Access, Microsoft Analysis Services, Diagnostic Manager, Microsoft Reporting Services, Autosys, Microsoft SQL Server Integration Services(SSIS), Litespeed, DTS Xchange, UNIX OS and UNIX shell scripting, Oracle APEX.

Confidential,MN Apr 08 to Mar 09
Role: Sr. SQL Server DBA

Responsibilities:

  • Involved in installation of SQL Server 2000 and 2005,Configration and Maintenance
  • Involved in Data modeling, designing and building relational databases.
  • Created various Cubes and Dimensions for SSAS project.
  • Worked with ASCMD command line utility for SSAS.
  • Verify, maintain & troubleshoot database backups, integrity checks and scheduled jobs.
  • Wrote triggers, stored Procedure, scripts, cursors for the bulk application, tested them on the test servers and moved them to the production.
  • Creating and managing schema objects such as tables, views, index, and procedures.
  • Involved in side by side migration from 2000 to 2005
  • Upgraded SQL Server 2000 to SQL Server 2005 on DEV and Testing Environment.
  • Worked on Development of system maintenance tasks such as Database Backup & Recovery, replication and apply in Dev and Testing Environment.
  • Assigned permission to user(s), roles), and object. Administrate security for server logins (Windows and SQL Accounts).
  • Installation of Replication Server, Configuration and Monitoring the replication, implemented Transactional Replication, Merge and Snapshot, writing scripts for automation, for creating publications, articles and running the snapshot agent job, so that the same scripts can be used from system test to production.
  • Identifying the bottlenecks and troubleshooting it for optimal performance.
  • Upgraded DTS packages to SQL Server 2005 Integration Services (SSIS) packages.
  • Supported Development Team in deploying and testing the application, which uses SQL Server backend.
  • Daily monitoring of the database performance, Dead lock and network issues.
  • Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity.
  • Detected and troubleshooted SQL Server related CPU,memory,I/O, disk space and other resource contention.
  • Created documentation to install SQL Server, apply service pack, hot fix and clustering installation.
  • Expertised in Security Issues such as creation and granting permissions on various Objects.
  • Prepared the reports for the day-to-day as well as weekly/monthly purposes.
  • Created documentation to install SQL Server 2005, apply service packs.
  • Provided 24 / 7 dedicated support to all Production and development servers.

Environment:
Microsoft Windows Server 2003,XP,Vista Microsoft SQL Server 2000/2005 Enterprise Edition, Microsoft Visual Studio 2005,VB 6, ADO, Active directory, ISA 2004, IIS, Net Framework 2, MS Access, Oracle, Oracle Apex, Query Analyzer, Event Viewer, Database Maintenance Plan Wizard,MOM SSIS ,SSRS. Crystal Reports, Visio2007, Spotlight.

Confidential,Jersey City, NJ Aug 07 to Mar 08
Role: SQL Server DBA /Developer

Responsibilities:

  • Monitored and maintained over 6 SQL Servers in Production, QA, Test and Development Environments.
  • Set up SQL Mail and Created Jobs to Automate & Scheduled many tasks.
  • Implementing Automated Backup and Database Maintenance / Cleanup jobs.
  • Imported Data from Text files and Excel Spread sheet into SQL Server 2000 database using DTS package.
  • Creating and maintaining documentation including data dictionary. Installation and maintenance of DBMS software and connectivity to client tool.
  • Implementing Automated Backup and Database Maintenance / Cleanup jobs.
  • Change management ensuring all changes are tested, communicated, approved, documented.
  • Setting up logical/physical backups for the databases.
  • Create packages, procedures, functions, and triggers; handle database performance and tuning.
  • Implemented replication model like Merge, Transactional and Snapshot.
  • Demonstrating Communication skills and leadership ability .Previous marketing and/or CRM expertise a plus. Demonstrating project management skills.
  • Backed up system and user databases related to Merge, Transactional and Snapshot Replication
  • Creating DTS Packages migration of data across different servers and Other Databases such as Oracle and DB2.
  • Participating in 24x7 on-call rotation. Good analytical and troubleshooting skills required. Been a good team player with good communication skills, and a can-do attitude.
  • Managing Logins, Users, Roles and User permissions
  • Application installation for database-centric applications like SAP and Siebel.
  • Assist Developers in writing and tuning new procedures.
  • Creating new procedures using Dynamic SQL and Table Variables.
  • Create and Modify procedures, Triggers and functions.

Environment:
SQL Server2000/2005,SSIS, SSRS,SSAS, T-SQLMOM, IIS ,Oracle, Active Directory ,ISA 2004, MTS & Windows 2000,2003 MS-Access, MS-Excel, Teradata, VB.net, DB2, TOAD, LITESPEED, Erwin, Sportlight.

Confidential,INDIA May 05 to June 07
Role: SQL Server DBA / DEVELOPER

Responsibilities:

  • Created and modified stored procedures, Triggers, Views.
  • Maintaining jobs for data massaging from production server to Business Objects server for generating daily reports for financial and marketing team.
  • Created and managed the database and objects.
  • Customization of DTS workflow thought active x task.
  • Managed and coordinate with remote user for change request and optimization of application.
  • Management and maintenance of data, including backups, data fixes, replication, restoration and high availability of operational systems
  • Configuration and management of security of company SQL servers, including troubleshooting
  • DTS for Import from Oracle & Excel for Analysis server.
  • Responsible for planning, executing, and maintaining data integration projects and database upgrades.
  • Ability to write SQL scripts. Hands-on experience with disaster recovery techniques and database failure contingency planning.
  • Monitoring SQL Server, at the physical server and database layer.
  • Significant experience in database redundancy strategies, and disaster recovery (Data Mirroring, Replication, Log Shipping, Clustering).
  • Windows 2003 multi-node clustering. Experience with transactional replication required Experience with MS BI Stack SSIS, SSRS and SSAS
  • Responsible for fine tuning of the database, trouble shooting, user administration, memory management, and running DBCC.
  • Involved in Performance tuning and Query Optimization.
  • Used multitask data pump in DTS/ETL.
  • Created DTS/ETL Packages to pull data from Oracle and Flat files and db2
  • Implemented transactional, Merge and Snapshot replication.
  • Responsible for creating tables, triggers, stored procedures, indexes.
  • Created and managed the database and objects.

Environment:
Windows 2000 Advanced Server, Active Directory, MS SQL Server 2000, Excel Objects, Oracle, MS projects, DB2, UNIX, ERWIN.

Hire Now