We provide IT Staff Augmentation Services!

Sql Server Dba Resume

New York, NY

PROFESSIONAL SUMMARY:

  • 17 years of overall experience in IT Industry.
  • Installations and configurations, Analysis, Design, Development, Testing, Administration, and implementation of Client/Server applications and relational databases Data Warehouse Design, Development,
  • Expert in designing and creating Tables, Index, Views, Stored Procedures, Triggers, Query tuning, planning and implementing Server Security and authentication utilizing, Develop Queries and T - SQL Scripts in MS SQL 7.0/ 2000/2005/2008 using Query Analyzer and Enterprise Manager
  • Profiler and Index Tuning Wizard. Strong skills in Microsoft SQL Server Database with three years of backend administration performed tuning and programming experience with analytical skills.
  • 7 years of Microsoft Business Intelligence technologies, DTS/SSIS
  • Expertise and having more than 15 months of experience in .NET Framework and its technologies VB .NET, ASP.NET. Expertise and more than a year of experience in Server-side web application development using ASP 3.0.
  • Expertise in Data Access methodologies of DAO, RDO, ADO, ODBC and OLEDB. Experienced in developing applications using HTML, VBScript and Perl. Good experience and understanding in Database concepts with Oracle 8i-11g, SaleForce

TECHNICAL EXPERIENCE:

Programming Languages: SQL, T-SQL, VB Script, Perl, HTML, DHTML,.NET, VB.NET, ASP.NET, Visual Basic 6.0, ASP 3.0

Software/Databases: SQL Server 7.0/8/ 2000/2005/2008 R2, SSRS,SSIS,SSAS, Oracle 8i-11, DB2, Informix, MS Access 97/2000/2003 , JDBC, ODBC, OLEDB, COM, DCOM, RedGate, SSRS 2000/2005/2008 , Crystal Reports 7.0/8.0/8.5/9/10/11 , SaleForce, OLTP, OLAP, Data Warehouse, PL/SQL, Visual Studio .NET, ADO.NET, ERWIN and Visio

Operating Systems: Windows 95/98/2000/NT/ 2000/2003/2008 4.0/ ME/XP/CE, MS DOS, UNIX, LINUX

PROFESSIONAL EXPERIENCE:

Confidential, NEW YORK, NY

SQL Server DBA

Technologies: SQL Server 2000/2005/2008 R2, Oracle 10g

Responsibilities:

  • Verify Daily Backups, Monitor Jobs History, Check on Backup Folders for previous night Backup Files as needed
  • Check Services and Instances to ensure they are running in parallel to receiving Alerts accordingly
  • Check SQL Server 2005 2008 Logs (Engine, Report, Analysis and SQL Agent)
  • Check Windows event Logs for SQL Server, Report Server, Analysis Server or SQL
  • Server Agent Entries, Visit SQL Error logs, Verify Backup and Maintenance steps
  • Analyze Applications errors and resolve as necessary
  • Check Jobs History and any logging created
  • Look for unusual Database (Data/Log) files growth, Check on Available/Occupied Disk space
  • Development/Test Database Refresh SQL Server Installations and tweaking
  • Investigate application issues and take action as necessary
  • Maintain Kofax/Markview application (windows side ) and Assist in troubleshooting
  • Resolve Windows application related issue
  • DBA Documentation: ongoing and including quick fixes to issues

Confidential, Brooklyn, NY

SQL Server DBA

Technologies: SQL Server 2000/2005/2008 R2, DB2 9, Oracle 10g, UNIX, SharePoint 2010

Responsibilities:

  • Install, Monitor, Patch, Maintain, and Performance Tune Production Databases while ensuring high levels of data availability(Mirroring, Clustering, Mirroring+Log Shipping, Replications, Log Shipping)
  • Provided comprehensive Cash, stocks, bonds and other holdings reports
  • Extracting and transforming data using SSIS from DB2 to SQL Server, Import/Export for transferring data between SQL Server.
  • Create procedures and queries with error handling in DB2
  • Build reports using SQL Server 2005/2008 Reporting Services reports.

Confidential, New York, NY

SQL Server DBA

Technologies: SQL Server 2000/2005/2008 R2, Perl, Oracle 11g, Sybase 12.5.0.3, SSAS, SSIS, SSRS, SFTP, SaleForce, Kronos

Responsibilities:

  • Installation of Sybase software and Sybase Replication.
  • Expertise in Sybase database setup, database upgrades, space management, backup and recovery
  • Diagnose and resolve performance issues, connectivity/security issues and database corruptions in a critical production environment
  • Worked largely on the automation of the backup and recovery using korn shell scripting.
  • The requirement was to extend the features of dump and load to developers to be able to refresh development environments at will with production data, and yet the keeping the refresh control still in the hands of the Sybase DBA's. Worked on a login and user addition script, that would add a login to a Sybase Server and all users and aliases to all databases on that Sybase Server and add the user to all the groups imitating the allocations of a like user or sample user.
  • Implemented MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster, Transaction and Snapshot replications in 2008/2005.
  • Enhancing a Perl/SQL Server employment site (MS IIS) with personalization, security, dynamically generated graphics, search features and bug-fixes.
  • Planned & executed of any upgrade such as Service Pack, Hot fixes etc.
  • Extracting and transforming data using SSIS from DB2 to SQL Server(conversion project to Kronos)
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Created, administered & maintained SQL Server Databases (Production, Development, Test and Staging Env.) for various groups such as Developer, QA, DA, User etc and ensured the Availability of the Database Server in a 24X7 Environment.
  • Managed security by defining roles and rights.
  • Create functions, procs and packages in Oracle 11g. Working with SQL*Loader
  • MS SQL Server 2000/2005/2008 backend programming of stored procedures and queries.
  • Daily support, troubleshooting, monitoring, optimization and tuning of server and Sybase environments across entire system, query tuning.
  • Working with decrypted data using SFTP server.
  • Establish and maintain sound backup and recovery policies and procedures.
  • Take care of the Database design and implementation. Implement and maintain database security (create and maintain users and roles, assign privileges) with Active Directory.
  • Support of production systems for database problem resolution/recovery, as well as assistance with production applications including Emergency off-hour support Monitoring databases using tools from Quest
  • SharePoint and SSRS integration

Confidential, Toledo, OH

SQL Server DBA

Technologies and tools: SQL Server 2005/2008R2, Oracle 10g, SAP, BI, Argent, Mom, Quest

Responsibilities:

  • Support Applications PeopleSoft and Manufactory applications
  • Install, Monitor, Patch, Maintain, and Performance Tune Production Databases while ensuring high levels of data availability(Mirroring, Clustering, Mirroring+Log Shipping, Replications, Log Shipping)
  • Setup MS SQL Server clustering, clustering with mirroring, mirroring with replication, Transaction and Snapshot replications in 2008/2005.
  • Backups/restores, monitoring SQL uptime, designing and maintaining DTS/SSIS packages.
  • Handled large volumes of Data Warehouse database. Designing and loading the data into data warehouse (ETL).
  • Utilized OLTP and T-SQL for monitoring SQL Server jobs in Windows 2003/2008 applications.
  • Database Design OLTP and OLAP using documentations and company business logic.
  • Establish and maintain sound backup and recovery policies and procedures.
  • Take care of the Database design and implementation. Implement and maintain database security (create and maintain users and roles, assign privileges) with Active Directory.
  • Support of production systems for database problem resolution/recovery, as well as assistance with production applications including Emergency off-hour supportMonitoring databases using tools from Quest, Argent, SCOM
  • Install, Monitor, Patch, Maintain, and Performance Tune Production Databases while ensuring high levels of data availability(Mirroring, Clustering, Mirroring+Log Shipping, Replications, Log Shipping)
  • Create databases; all objects (tables, views, store procedures, functions...) in MS SQL Server 2008 using T-SQL (DDL).
  • Setup SQL Server email alerts with SMTP
  • Transfer data from Oracle. Create objects in Oracle 10g.
  • Installing and managing 3rd party vendor applications and dependent components, including packages that utilize IIS, Microsoft Reporting Services, etc.
  • Create and setup monitoring all jobs and servers settings using SSIS and SSRS 2008

Confidential, Brooklyn, NY

SQL Server DBA

Technologies: SQL Server 2000/2005/2008 R2,BI, Oracle 10g

Responsibilities:

  • Backups/restores, monitoring SQL uptime, designing and maintaining DTS/SSIS packages.
  • Setup, configure and maintain cluster SQL Server 2005.
  • Database Design, Development, Performance Tuning, implementing different types of Replication Models like Snapshot, and Transactional in 2008/2005/2000 environment, Log Shipping, Cluster and Mirroring 2008/2005
  • Export and import data from various MSSQL servers 2000/2005, Oracle 10g using SSIS, DTS and BCP regarding Food Stamps, Medicate and Medicare programs.
  • Created the tables, store procedures, functions, worked with flat files, insert from flat files, and transfer to flat files.
  • Setup varied types of computer hardware and software with varied computer and network operating systems
  • Take participation in migration from SQL server 2000 to SQL server 2005.
  • Handled large volumes of Data Warehouse database. Designing and loading the data into data warehouse (ETL).
  • Using VBScript in ActiveX for DTS and SSIS packages.
  • MS SQL Server 2000/2005/2008 backend programming of stored procedures and queries.
  • Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system, query tuning.
  • Monthly and daily reports for the number of transactions using SSAS, create cubes, MDX queries.
  • Was making changes in store procedure in Oracle and code in C#.
  • Involved in Migration from heterogeneous sources including Oracle to MS SQL Server.

Confidential, New York, NY

SQL Server DBA

Technologies: MS SQL Server 2005/2000, BI, Perl

Responsibilities:

  • Using Perl to automate content preparation for WAP and SMS subscription services.
  • Extracting and transforming data using SSIS.
  • Created Triggers to enforce data and referential integrity.
  • Database Schema and Modeling.
  • Defined Check constraints, Business Rules, Indexes, and Views.
  • Wrote queries, store procedure in Oracle 10g.
  • Worked on SSIS Package, Import/Export for transferring data between SQL Server.
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Take participation in migration from SQL server 2000 to SQL server 2005.
  • Handled large volumes of Data Warehouse database. Designing and loading the data into data warehouse (ETL).
  • Using VBScript in ActiveX for DTS and SSIS packages.
  • Expert in extracting and transforming data using DTS/SSIS Import Export Data, DTS/SSIS Packages, Bulk Insert and BCP.
  • MS SQL Server 2000/2005/2008 backend programming of stored procedures and queries.
  • Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system, query tuning.
  • Monthly and daily reports for the number of transactions using SSAS, create cubes, MDX queries.
  • Was making changes in store procedure in Oracle and code in C#.
  • Involved in Migration from heterogeneous sources including Oracle to MS SQL Server.
  • Created new tables, written stored procedures for application Developers and some user defined functions.

Confidential, NY

SQL Server DBA

Technologies: SQL Server 2000/2005, DB2, Oracle 9g, DB2,SSIS,SSRS,SSAS, MS Project MS SQL Server 2005, SAP, BI

Responsibilities:

  • Support Applications for FoodStamps and SSI programms
  • Administer SQL Server 2000/2005 Database including support for existing and new projects (1 server- MS SQL Server 2000 and 8 servers - MS SQL Server 2005), more of 2 TB size of databases and include tables with 100 millions rows.
  • Install, setup and configure Database - SQL Server 2005,clustering,replicaions
  • Migrate from Oracle to MS SQL Server 2005
  • Test and apply patches/fix packs for SQL Server 2000 /2005
  • Manage and implement an upgrade from SQL Server 2000 to SQL Server 2005
  • Creating performing and tuning complex queries, triggers, functions, and stored procedures to fulfill business requirements .Monitor the overall performance of the database to recommend and initiate actions to improve/optimize performance.
  • Coordinate with eCommerce platform hosting vendor(s) DBAs to ensure proper support, maintenance, and tuning of the database.
  • Assist in the development and maintenance of ETL scripts for efficiently loading and extracting data from the database when necessary Maintain, create, and improve database related documentation
  • Implement database security and user access
  • Implement daily database backup schedules and/or routines for disaster/recovery
  • Maintain, create and improve replication
  • Create reports using reporting services or equivalent

Confidential, Bronx, NY

SQL Server DBA

Technologies: MS SQL Server 2005/2000, Access 2003(DAO, ADO), VB.NET, SAS 9.1, Cognos

Responsibilities:

  • MS SQL Server 2005/2000 created databases, store procedures, triggers, queries, monitoring and tuning, optimizing and troubleshooting, migration and reports.
  • Access 2003(DAO, ADO) Created applications to work with the Databases.
  • Setup local network and configured TCP/IP.
  • Performed operating system and database performance monitoring, tuning and Code Optimization.
  • Utilized OLTP, OLAP, SSIS, OLAP cubes, MDX, ODBC, OLE-DB and T-SQL for monitoring SQL Server jobs in Windows NT applications.
  • Created new and modified existing databases, Tables, Indexes, Stored Procedures and Triggers in SQL Server 2000/2005 as necessary based on organizational needs.
  • Established backup and recovery procedures for all application production data.
  • Export and import data from various MSSQL server 2000/2005 using SSIS, DTS and BCP.
  • SQL Reporting Services, Reporting Crystal Reports X/XI, Crystal Enterprise upgrading to SQL Server 2005

Confidential

SQL Server DBA

Technologies: Windows NT 4.0/2000 Server Professional Series, SQL Server 6.5/7.0/2000 , Oracle 6,OLTP, OLAP, ODBC, OLE-DB, Visual Basic 6.0, Data Warehouse, Crystal Reports 7/8,.NET, ASP, MS Excel, MS DOS

Responsibilities:

  • Data Warehouse Design, Development and Implementation Experience.
  • Wrote stored procedures, giving permissions to tables, database and views.
  • Defined user roles and security logins through Enterprise Manager.
  • Used SQL Profiler to monitor the execution sequence of SQL scripts.
  • Created, backed-up and restored databases through SQL Wizards.
  • Database Administration, Data warehousing, Database Modeling, Architecting, design and development in SQL Server 2000, .NET, VB, ASP.
  • Wrote Stored Procedures, Triggers, Functions.
  • Architect and designed a MS SQL Server 2000 database for Arrival and Charge of the Goods.
  • Maintained the SQL Server Database and performed Tuning, Backups, DTS Verify SQL Server services (SQL Server, SQL EXEC and SQL Mail) status on daily and hourly basis.
  • Optimization and automation of data loading procedures for accounting, pricing and catalog, development of data test and staging servers and creation of policies to guide use of same.
  • Performed operating system and database performance monitoring and tuning.
  • Utilized OLTP, OLAP, ODBC, OLE-DB and T-SQL for monitoring SQL Server jobs in Windows NT applications.
  • Created new and modified existing databases, Tables, Indexes, Stored Procedures and Triggers in SQL Server 6.5/7.0 as necessary based on organizational needs.
  • Established backup and recovery procedures for all application production data.
  • Export and import data from various MSSQL server 6.5/7.0/2000 , AS/400 and XL data using DTS and BCP.
  • DBA (hand-coded ETL) support mapping external (trading partner, financial settlements) data to targets, MS excel, DOS .bat files technology.
  • Setup and install desktops PC and local network.
  • Support Compaq and Novell Servers

Hire Now