We provide IT Staff Augmentation Services!

Sql Server Dba /developer Resume

3.00/5 (Submit Your Rating)

Professional Summary

  • 8 years of IT Experience in managing multiple MS SQL 2000 & 2005 & 2008 servers in Finance, Banking and various domains.
  • Expert Level skills in providing 24x7 DBA support in Production, QA and Development.
  • Involved in day-to-day monitoring and maintenance, problem investigation and resolution, SQL and database optimization and tuning as well as researching, analyzing, and recommending patches, upgrades, and new technologies surrounding all aspects of data management using relational databases.
  • In depth knowledge working with Windows, SQL, IIS, NLBS Clustering, SAN and infrastructure.
  • Migration experience with multiple databases/servers from SQL 2000 to SQL 2005 and SQL 2005 to SQL 2008R2.
  • Experience and Knowledge on High availability & Disaster Recovery options like Replication/log shipping/Mirroring.
  • Designed and Configured Partitioning of Tables and Indexes to Improve query performance in SQL 2008 R2 especially considering memory limitations.
  • Implemented Concepts like Data Compression and Backup compression reducing I/O and Transparent Data Encryption for encrypting data and log files at database level in SQL 2008 R2.
  • Conducted root cause and analysis for database incidents and problems.
  • Suggested Application level tuning changes for code, queries, SQL objects which may not be performing up to the optimum database performance standards.
  • Well Experienced in Performance Tuning (System level/Database Level/Query Level) and optimization.
  • Thorough understanding of blocking/lock issues, Tempdb Optimization, Filegroup management
  • Experience of Export/Import Database Objects / Tables /data using DTS and SSIS packages.
  • Experience in working with VLDB databases up to 2TB, Managing Backups, Disk & Drive Space issues, managing indexes.
  • Experience in SQL Server Replication models, writing Stored Procedures, Triggers, and Managing Indexes etc.
  • Involved in migration from MS SQL Server 2000/7.0 to MS SQL Server 2005, DTS to SSIS.
  • Experience using Resource Governor and Policy Based Management system
  • Used SQL 2000 DTS as a means of ETL for creation of DTS packages for various operations. Converted DTS packages of SQL 2000 to SSIS packages in SQL 2005. Also scheduled DTS packages and SSIS packages as jobs to perform various tasks.
  • Thorough knowledge on SAN environments, RAID levels, VMware Environments.
  • Experience in Installation and configuration of SSRS, SSIS and SSAS.
  • Thorough understanding of tools like Perfmon, SQL Profiler, DTA, DB Artisan, LiteSpeed etc.

Education & Certifications

Bachelor of Engineering (B.E.)



Technical Skills

Programming Languages:

T-SQL, PL/SQL, ASP, .Net, VB, C, C++, Unix, XML.

RDBMS:

MS SQL Server 2008R2/2008/2005/2000/7.0, MS-Access 2005/2000, DB2, Sybase ASE 15.0.

Web Tools:

MS-Front Page, Internet Information Server (IIS), FTP, TCP/IP, SMTP, LAN, MS-Outlook Express.

Operating Systems:

Windows 2003, 2000 Enterprise Server, Windows NT 5.0 /4.0 /3.5, MS DOS.

Database
Tools:

SSMS, BIDS, DTA, SQL Profiler, DTS,, DTSRUN, MS Visio, SQL Loader, Import & Export (DTS), DTSXChange, SSRS, SSAS, SSIS, Erwin, LiteSpeed, Crystal Reports 10.0,Share Point, SQLCMD, CLR Integration, Oracle Designer

Utility
Tools:

MS Office, MS Project, Rational Clear Quest, Visual Source Safe 6.0, System Center Operations Manager (SCOM), Informatica, Visio 2007.

Professional Experience

Confidential,Bloomington, MN. April’ 2012 – Present
Role: SQL Server DBA /Developer



Confidential,believes that every student deserves an opportunity to go to college, regardless of their financial status. IN 1958, an Optometrist in Fall River, Mass., had a simple but profound idea—if everyone in his community gave just a dollar to an educational fund, it would be enough to help nearly every student in the community attend college. Dr. Irving Fradkin called his plan "Dollars for Scholars," and it has expanded into what today is the nation\'s largest non-profit, private-sector scholarship and educational support organization—Scholarship America.

Responsibilities:

  • Worked with Legacy Oracle System and SQL server 2008 R2 Servers.
  • Data Migration from Legacy system to SQL Server 2008 R2 databases.
  • Designed and worked with Different RDBMS.
  • Used Microsoft SQL Server Migration Assistant 2008 for Oracle.
  • Created Normalized staging databases and used them for efficient data migration process.
  • Created Linked Server to Oracle 11 to open query for SSRS.
  • Creating SSIS packages for Nightly pulls from Legacy to SQL server 2008R2 server.
  • Performance Tuning to increase the speed and performance of website, tuning hardware and software requirements.
  • Created Numerous Stored procedures, Functions for data analysis.
  • In SQL 2008R2 set up Database Partitioning to improve query performance.
  • Introduced and Implemented Features like Data and Backup compression and transparent data encryption to reduce I/O and to maintain security respectively.
  • Suggested and modified code and schema changes for database objects and scripts following Best practices.
  • Monitoring and Troubleshooting jobs, Backups and Restore database policies.

Confidential,Wayzata, MN. March’ 2011 –April’ 2012
Role: Senior SQL Server & Sybase DBA
Confidential,is a privately held, multinational corporation, based in Minnetonka, Minnesota. Founded in 1865, it is now the largest privately held corporation in the United States in terms of revenue. If it were a public company, it would rank in the top 10 companies in the Fortune 500. Some of Cargill\'s major businesses are trading, purchasing and distributing grain and other agricultural commodities; trading in energy, steel and transport; the manufacture and sale of livestock and feed; producing food ingredients such as starch and glucose syrup, vegetable oils and fats for application in processed foods and industrial use.

Responsibilities:

  • Worked with Terabytes of Data with over 500 databases.
  • Installed recommended service packs and security patches on production, test and development servers.
  • Designed and worked with Different RDBMS and applications collecting customers information of all BU’s into a Database and generated a Report on Customer’s overall Expenditure and Business to Cargill Agriculture business.
  • Created Linked Server to Oracle 11 to openquery for SSRS.
  • Set up data Replication from Sybase ASE 12 and Sybase ASE 15 to SQL Server Dev and Production systems.
  • Performance Tuning to increase the speed and performance of CargillAg.com tuning hardware and software requirements.
  • Upgraded Test and Production databases from SQL 2005 to SQL 2008R2.
  • In SQL 2008R2 set up Database Partitioning to improve query performance.
  • Introduced and Implemented Features like Data and Backup compression and transparent data encryption to reduce I/O and to maintain security respectively.
  • Suggested and modified code and schema changes for database objects and scripts.
  • Performed a Security Audit for all SQL and Sybase servers.
  • Utilized Resource Governor to handle two applications on the Server.
  • Supported and learned a very complicated Replication system between hundreds of Sybase and SQL Servers.Tuning Queries and Database performance using tools SQL Server Tuning Advisor, SQL Server Profiler, Perfmon and Best Practice Analyzer.
  • ETL tool Running 24/7 transferring data between the SQL Servers.
  • Used Putty to connect and work with unix servers hosting Sybase databases.
  • Worked on UNIX operating system hosting Sybase and successfully applying patches and deploys.
  • Expertise in Using Third party tools like Dbartisan, sqlDeveloper, Sybase central to Oracle, Sybase servers .Worked with TOAD and LiteSpeed for Backup and restore.
  • Monitoring and Troubleshooting jobs, Backups and Restore database policies.
  • Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
  • Thorough understanding of standard SOP’s, SLA’s and change control management process.
  • Generating Reports as per the requirement using SSRS 2005/2008.
  • Coordinated physical changes and performance monitoring of two replicated production servers and two development servers.
  • Develop SSIS Packages to transform data from excel/Access file to SQL Server database.

Environment: SQL Server 2000/2005/2008,Sybase ASE 12,15 .Sybase Replication 15 MS Access, Windows NT/2008/2003 Advanced Server, T-SQL, SSIS, and SSRS, PLSQL ,UNIX.

Confidential,Bradenton ,FL . Jan’2011 – March ‘2011
Role: SQL Server DBA
Confidential,is a world-class training facility for athletic, academic and personal development. For more than 30 years, the Academy\'s training methods have helped youth, adult , collegiate and professional athletes improve in sport and life. Consisting of the IMG Bollettieri Tennis Academy, IMG Leadbetter Golf Academy, IMG Football Academy, IMG Baseball Academy, IMG Basketball Academy, IMG Lacrosse Academy, IMG Soccer Academy, and the IMG Performance Institute, the Bradenton, Florida - based Academy attracts more than 12,000 athletes from approximately 80 countries every year.

Responsibilities:

  • Providing support to Production, QA and Development servers.
  • Migrating of databases from Oracle to SQL server 2008.
  • Migrating data from MS Access to SQL Server 2005/2008.
  • Successfully migrated the data from Visual Foxpro to SQL Server 2008.
  • Monitoring and Troubleshooting jobs, Backups and Restore database policies.
  • Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
  • Created SSIS packages to import data from VFP, Oracle and MS access.
  • Writing DTS (SQL 2K) as well as SSIS (SQL 2K5) packages for daily sales and delivery reports as well as for adhoc data transforms and data extraction for the Data Migration team and also upgraded DTS packages to SSIS packages.
  • Assisted in the design and development of the data warehouse.
  • Generating Reports as per the requirement using SSRS 2005/2008.
  • Coordinated physical changes and performance monitoring of two replicated production servers and two development servers.
  • Designing Logical and Physical Data Model with Erwin tools.
  • Develop SSIS Packages to transform data from excel/Access file to SQL Server database.
  • Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers etc as required.
  • Tuning Queries and Database performance using tools SQL Server Tuning Advisor, SQL Server Profiler.

Environment: SQL Server 2000/2005/2008 , MS Access, Windows NT/2000/2003 Advanced Server, T-SQL, SSIS, and SSRS.

Confidential,Atlanta, GA. June’10 –Jan ’11
Role: SQL Server DBA



Confidential,is one of the nation\'s largest financial services holding companies. Atlanta-based SunTrust enjoys leading positions in some of the most attractive markets in the United States and also serves clients in selected markets nationally. The Company’s mission is to help people and institutions prosper by providing financial services that meet the needs, exceed the expectations, and enhance the lives of our clients, communities, colleagues, and ultimately our shareholders. SunTrust’s 1,670 retail branches and 2,928 ATMs are located primarily in east coast.

Responsibilities:

  • Providing 24x7 supports to Production, QA and Development servers.
  • Involved in installations, upgrades, patches and fixes.
  • Successfully migrated the data from SQL Server 2000 to SQL Server 2005/2008.
  • Worked on data compression features of SQL 2008 R2.
  • Monitoring and Troubleshooting jobs, Backups and Restore database policies.
  • Worked on high availability SQL solutions, including Log shipping, Replication and SQL Server clustering.
  • MySQL database performance optimization.
  • Worked with Application manager to accommodate data to MYSQL.
  • Working experience on Active -Passive and Active -Active Clustering model.
  • Successfully migrated SQL 2005 mirror model to SQL 2008 cluster model.
  • Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
  • Work with project teams for Migrating data from MS Access to SQL Server 2005/2008.
  • Writing DTS (SQL 2K) as well as SSIS (SQL 2K5) packages for daily sales and delivery reports as well as for adhoc data transforms and data extraction for the Data Migration team and also upgraded DTS packages to SSIS packages.
  • Generating Reports as per the requirement using SSRS 2005/2008.
  • Configuring and Setting up BMC Patrol alerts in Production, Preview, QA & DR, Test environment.
  • Coordinated physical changes and performance monitoring of two replicated production servers and two development servers.
  • Designing Logical and Physical Data Model with Erwin tools.
  • Develop SSIS Packages to transform data from excel/Access file to SQL Server database.
  • Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers etc as required.
  • Tuning Queries and Database performance using tools SQL Server Tuning Advisor, SQL Server Profiler.

Environment: SQL Server 2000/2005/2008 , MS Access, Windows NT/2000/2003 Advanced Server, T-SQL, SSIS, and SSRS.

Confidential,Fort Worth, TX May’ 09 –May’ 10
Role: SQL Server DBA



Confidential,is a provider of leading-edge transportation, logistics and supply chain management solutions worldwide. Ryder\'s product offerings include: Fleet Management Solutions (FMS), which provides leasing, rental and programmed maintenance of trucks, tractors and trailers to commercial customers; Supply Chain Solutions (SCS), which manages the movement of materials and related information from the acquisition of raw materials to the delivery of finished products to end-users; and Dedicated Contract Carriage (DCC), which provides a turn-key transportation service that includes vehicles, drivers, routing and scheduling. Ryder serves customer needs throughout North America and in Latin America, Europe and Asia.

Responsibilities:

  • Replicated SQL servers handling thousands of transactions per day with 24/7 uptime to service clients.
  • Actively involved in creation of database, modified tables, triggers, and store procedures to clean and validate the data to meet the company specifications.
  • Data Transformation Activities using SSIS Import/ Export for transferring data between different databases like oracle. Design new SSIS packages as per needs,
  • Running Index tuning wizard and rebuilding indexes for faster query response.
  • Created the logical and physical data modeling using Erwin tool..
  • Generated different types of Reports (Tabular/Matrix) using MS SQL Server Reporting Service (SSRS).
  • Designing and optimizing all the SSIS packages in 2005/2008.
  • Created Backups Strategies for databases and automated the process.
  • Provided support for Clustering environment, DTS packages and Transactional/Merge replication.
  • Implemented a Customer Records Management system using SharePoint Portal Server.
  • Incorporating business logic in SSIS packages while converting from Oracle, MS Access and Text to SQL Server. Creating new database/tables to put in the extracted data and rebuilding the relationship.
  • Involved in Designing and Implementation of data warehousing solution which includes Building an OLAP database, creating data source.
  • Managed databases on multiple disks using RAID technology.
  • Created distributed partitioned views, debugging / troubleshooting stored procedures, upgrading existing ones.

Environment: SQL Server 2000/2005/2008, Oracle, MS Access, T-SQL, SSIS, SSRS, Window 2003.

Confidential,Cleveland, Ohio Nov‘08 – Apr ’09
Role : SQL SERVER DBA____________________________________________________________________

Confidential, is one of the leading providers of auto, home and life insurance in the United States. As a consultant at QualChoice for the Human Resource Management System (HRMS), part of an ERP (Enterprise Resource Planning), developed and helped to implement HRMS that is designed to handle the human resource activities for the organization. HRMS is a web based three-tier architecture system which provides information about employee data, new hire, applicants, promotion, demotion, leave or absence, payroll data, and change of certain business rules required development of new modules to the system.

Responsibilities:

  • Performed migration of servers from SQL Server 2000 to 2005.
  • Implementation of an enterprise management application and its supporting Microsoft SQL Server 2005 database. Responsibilities included attending team meetings database analysis and design as well as data mapping for a conversion from a legacy flat file database to a relational database
  • Creating and managing schema objects such as tables, views, clusters, indexes, procedures, triggers and maintained Referential Integrity.
  • Monitoring all activities of the server by monitoring the daily SQL jobs, SQL Server error logs and Windows error logs.
  • Resolved database performance capacity, replication and other distributed data issues.
  • Working experience in clustered environment (active / passive) to further increase scalability and stability of business critical systems.
  • Created a mirrored database on the report server using Database Mirroring with High Performance Mode.

Environment: T-SQL, SQL Server 2000/2005, DTS, BCP, Crystal Reports, VBA , MS Reporting Services, Performance Tuning, Clustering, Bulk Insert, HTML, DHTML, PL\\SQL, Windows 2000 ,Erwin.6.0

Confidential, Jan’08 - Oct‘08
Seattle, WA.
SQL Server DBA



Confidential,This project is initiated to measure quality of service for operational perspective. Customer calls, trace, claims and invoice information from various systems and sources is downloaded, processed and analyzed according to the defined business rules. Aggregated data is stored in SQL Server to feed web reports and ad hoc queries

Responsibilities:

  • Involved in designing of Conceptual Logical Model and Physical Model
  • Design/Build Extract Transform Load procedures in SQL Server 2000 using DTS packages to import/export data feeds to/from data warehouse and claim systems
  • Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
  • Created SSIS packages to export data from Oracle to SQL Server Database.
  • Performance: Analyzed database performance with SQL Profiler and Optimized indexes to significantly improve queries.
  • Supported clustering and replication for servers.
  • Responsible for tier 2 support for more than 10 SQL Servers in a 24x7 mission-critical/production environment.
  • Maintained cluster servers to provide high availability.
  • Design/Build Extract Transform Load procedures in SQL Server 2000 using DTS packages to import/export data feeds to/from data warehouse and claim systems
  • Used ER/Studio to reverse engineer legacy database from Sybase to SQL Server.
  • Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA
  • Configured two Active/Passive Clustering setups for failover on production servers. This included installing windows cluster service and SQL 2000 on windows 2003 enterprise edition.

Environment: SQL Server 2005, SQL Server 2000, T-SQL, Oracle, MS Access, Windows 2000/NT/XP, MS Reporting Services, Delphi, DB2, Microsoft Visual Source safe.

Confidential,India Jun’06 – Dec ‘07
Role: SQL Server DBA______________________________________________________________________

The Company is manufacturing gearbox for various kinds of industries. The project was about Accounting and Inventory Control System. The application was contain different types of reports like Purchase Register, Sales Register, Stock Register, Party wise Sales Report, and Product wise Sales Report, Date/Party wise Outstanding Statement, Account Receipt/Payment Statement, Account Ledgers, and Trial Balance.

Responsibilities:

  • Involved in Data modeling to develop the database design using ERwin 4.0
  • Involved in designing of Conceptual Logical Model and Physical Model.
  • Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
  • Created SQL reports, data extraction and data loading scripts for different databases and schemas.
  • Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
  • Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
  • Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures
  • Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances
  • Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
  • Managed the products and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.

Environment: SQL Server 2000, T-SQL, CVS, Windows NT/2000/XP

Confidential,India May’05 – May’06
Role: SQL Server Developer_________________________________________________________________

Confidential,for the Human Resource Management System (HRMS), part of an ERP (Enterprise Resource Planning), developed and helped to implement HRMS that is designed to handle the human resource activities for the organization. HRMS is a web based three-tier architecture system which provides information about employee data, new hire, applicants, promotion, demotion, leave or absence, payroll data, and change of certain business rules required development of new modules to the system.

Responsibilities:

  • Actively participated in developing logical design of database incorporating business logic and user requirements.
  • Installed and Configured the SQL server 2000 and implemented physical design on SQL server 2000.
  • Created/reallocated database objects on appropriate Filegroups to ease maintenance and improve data access performance.
  • Created indexed generic views to enforce security on patient’s data and triggers on them to facilitate consistent data entry into the database.
  • Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
  • Implemented Security which included creating Logins, Users and granting permissions to users.
  • Providing supports to Production, Preview and Development servers.
  • Configuring and implementing Microsoft Operation Manager 2000 (MOM) in Production, Preview and Development environment to monitored SQL server activities.

Environment: SQL Server 2000, T-SQL, DTS, Windows NT/ 2000

We'd love your feedback!