SQL Server DBA
Resume:
SUMMARY
• Over Six & half years of professional experience as SQL SERVER Database Administrator and Production Server maintenance in Finance, Health care and Manufacturing.
• Expert level skills in Data Modeling, Data Mapping, ER Diagrams, Table Normalization, Optimization and Tuning.
• Migrating SQL Server 2000 databases to SQL Server 2005.
• Extensive experience with SQL Server 2005/7.
• Used SCOM to automate and centralize multiple SQL servers.
• Strong web design knowledge using PHP and HTML.
• Experience in SQL Server 2005 concepts SSIS (SQL Server Integration Services), SSAS (Analysis Services) and SSRS (Reporting Services).
• Created centralized data warehouse OLAP applications with OLAP services in SQL Server and build cubes with many dimensions using both star and snow flake schemas.
• Managed inventory using Infor’s ERP SyteLine.
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases.
• Experience in software Analysis, Design, Development, Testing, Implementation and production, support of Client/Server, COTS and Web based application development support.
• Experience in installation, upgrade and configuration of Microsoft SQL Server and databases.
• Maintained multiple Sybase servers on UNIX platforms.
• Experience in Microsoft SQL Server Database Administration including planning, implementing, backup, and recovery strategies.
• Expert in creating indexed Views, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Experience in Troubleshooting, Technical Analysis, Code Review, Implementation, 24 x 7 production support
• Experience in extracting and transforming data using DTS Import/Export Data, Bulk Insert, BCP and DTS Packages from Heterogeneous database.
• Experience in different team projects with good project implementation experience, team skills, troubleshooting, presentation abilities and issue resolution capabilities.
• Excellent communication, analytical and inter personal skills and ability to learn new concepts.
• Skilled at assessing client needs, working in a group, suggesting ideas that enhance efficiency and maximize performance, implementing cutting-edge technology solutions, and training/supporting end users.
• Flexible and versatile to adapt to any new environment and work on any project.
TECHNICAL SKILLS:
Operating Systems: Windows 3.x/9x/ME/NT/2000/XP/Vista, Server 2003, Exchange 2003, UNIX, Solaris, MAC OS X
Databases: MS SQL Server 2005/2000/7.0/6.x, MySQL, Pervasive v8, Sybase Server, MS Office Access 2003.
ETL Tools: Data Integrator, DTS (Data transformation services), Integration Services.
Database Tools: SCOM, Red Gate Bundles, LiteSpeed SQL Profiler, SQL Query Analyzer, Index Analyzer, DTS Import/Export, Backup Server, Replication server, OLAP Services, SQL Agents, SQL Alerts, SQL Jobs, SQL Mail, SQL Client Configuration utility, Replication Tools.
Data Modeling: ER-Win v 4.0, Visio 5.0.
Languages: T-SQL, P-SQL, HTML, AJAX, PHP, XML, C, C++, Java, JavaScript and PL/SQL
Reporting Tools: Crystal reports, SSRS.
Applications: PRO Financial, PTE Financial, MS Sharepoint Server 2007, VM Ware, Backup Exec Agent, Infor ERP SyteLine, Cadence, MATLAB 5.3, Maple 6.0, PSPICE, Microsoft Office Suite, Adobe Photoshop, Cold Fusion, Acrobat Reader/Writer, Adobe Golive, Flash, Coldfusion, Dreamweaver, Mulberry, Pine.
PROFESSIONAL EXPERIENCE
Acitve Health Management (New York, NY) Apr 2008- Current
Sr. SQL Server DBA
Active Health is an information-driven care management company partly owned by Aetna Health Insurance that enables doctors and patients to work together to make better clinical decisions. The CSID database system mainly consisted of 22 Sql servers with a massive SAN environment maintained by Microsoft’s SCOM. The main purpose of this project was to migrate and upgrade the database engine to SQL Server 2008 with high availability replication and log shipping and to support the front-end web application.
Responsibilities:
• Extensive setup and maintenance of heterogeneous Replication Servers.
• Created logical and physical models using ERWIN.
• Maintained and supported MySQL Server Enterprise.
• Heavy migration to SQL Server 2008 using SSIS, DTS and Data Integrator.
• Tuned the entire instance for performance enhancements. Assisted COTS developers for query optimization.
• All replication, backup and monitoring maintained by centralized SCOM.
• Front and back end application development support.
• Synced data to MS Office using feedback server.
• Extensive SSAS knowledge for developing and implementing data warehousing.
• Fine tuned underneath HTML and PHP code for better performance and compatibility with Sql server 2000/2005.
• Heavy OLAP and CUBE processing.
• Troubleshoot development problems and work effectively with other team members to identify and address problems.
• Troubleshooting feedback server with connectivity.
• Used Microsoft .NET on Visual SourceSafe for production support.
• Sent out automated emails and faxes to clients as part of announcement and marketing purpose.
• Increased database Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Designed, developed, tested and implemented complex stored procedures, triggers, and functions and Triggers to implement business rules.
• Used SSRS for daily client reporting.
• Configured log shipping for production server.
• Configuration and production support using VMware.
• Prepared proper capacity, backup and recovery plans.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Troubleshooting DTS, SSIS and daily jobs.
• Created users, roles and granting and revoking privileges.
• Assigned full-fledged security for SQL Server 2005/2008.
• Worked on DTS Package, DTS Import/Export for transferring data from heterogeneous database.
• Involved in Data migration (import & export - BCP) from Text to SQL Server
• Planned complete Back-up of Database and Restored the Database from Disaster Recovery
• Coordinating post-implementation events such as testing
• Using Normalization techniques, eased process of data load, transformation and data extraction.
• Used Microsoft Office Suit for data integration.
• Configured Different RAID Levels (Redundant Array of Independent Disks).
• Designed DDL and DML, developed stored procedures and views for managing efficient data retrieval.
• Developed user defined functions and triggers.
• Used database consistency checks using DBCC utilities.
• Created Linked Servers for data retrieval using OLE DB data sources and providers.
Environment: SQL Server 2000/2005/2008, MySQL, SCOM, SSIS, SSAS, SSRS, DTS, SQL Profiler, BCP, Windows 2003/2000, ERWIN, Feedback server, ColdFusion, VMWare, LiteSpeed Backup.
MarketAxess (New York, NY) Nov 2007- Apr 2008
Sr. SQL Server DBA
MarketAxess offers its institutional investor clients access to a broad inventory of U.S. high-grade corporate bonds, which is provided and updated daily by its electronic trading platform a multi-dealer disclosed counter-party model. The database system mainly consisted of 50 Sql servers and 50 Oracle servers, and being the sole SQL DBA Incharge of all the Sql servers. Supported web based trading platform.
Responsibilities:
• Participated in developing logical model and implementing requirements on SQL Server 2000/2005
• Actively participated in gathering of User Requirement and System Specification.
• Created new database logical and physical design to fit new business requirement and implemented new design into SQL Server 2000.
• Fine-tuned using AJAX and HTML for database compatibility.
• Used Microsoft .NET on Visual SourceSafe for production support.
• Designed/Implemented a reporting dashboard for use by the SQL Reporting Services group using Visual Studio
• SSIS, DTS, SSRS and Data Integrator.
• Used MySQL to extract and transform data to SQL Server.
• Created database triggers to implement business requirements.
• Created complex Stored Procedures and Functions to support the front-end application.
• Optimize SQL queries for improved performance and availability.
• Successfully created schema change scripts to existing objects to synchronize with changing business rules.
• Monitored growth of database objects for capacity planning.
• Worked with Quality assurance to develop test plans and test cases to conduct system testing.
• Developed DTS Packages to get the reports, routinely, in the excel sheets, required by the managers for analysis.
• Actively participated in UAT for various modules.
• Prepared user manual and technical support manual using Microsoft Office Suit.
• Responsible for report generation using crystal reports based on business requirements.
Environment: SQL Server 2000/2005, MySQL, SSIS, Windows 2003/2000, ColdFusion, Microsoft Access 2003, Red Gate Backup.
Fiserv Insurance Solutions (Cedar Rapids, IA) Aug 2007 – Oct 2007
SQL Server Developer/DBA
Fiserv is a Fortune 500 company that delivers technology, systems, and services to help businesses manage and profit from information, PTE Financial being one of its most successful front-end applications. PRO Financial, the next generation of PTE Financial has already been chosen by 50 companies for its high-performance General Ledger and Accounts Payable solutions. These powerful applications use SQL Server 2005 to handle the speed and volume requirements of mid-size and larger insurers.
Responsibilities:
• Implemented user Training and provided technical support.
• Heavy migration using SSIS, DTS and Data Integrator.
• Designed and developed client specific distributed partitioned views.
• Prepared proper capacity, backup and recovery plans.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Used Microsoft .NET on Visual Sourcesafe for production support.
• Created users, roles and granting and revoking privileges.
• Assigned full-fledged security for SQL Server 2005.
• Worked on DTS Package, DTS Import/Export for transferring data from MS Access.
• Involved in Data migration (import & export - BCP) from Text to SQL Server
• Configured Replication Server.
• Worked on a Terabytes of Data.
• Planned complete Back-up of Database and Restored the Database from Disaster Recovery
• Generating ad-hoc reports using Microsoft Office Suit -Access and Crystal Reports
• Coordinating post-implementation events such as testing
• Using Normalization techniques, eased process of data load, transformation and data extraction.
• Configured Different RAID Levels (Redundant Array of Independent Disks).
• Implement SQL Server Log Shipping.
• Designed DDL and DML, developed stored procedures and views for managing efficient data retrieval.
• Developed user defined functions and triggers.
• Fine tuned SQL queries after analyzing Execution Plan.
• Used database consistency checks using DBCC utilities.
• Created Linked Servers for data retrieval using OLE DB data sources and providers.
• Wrote distributed queries for Linked Servers.
Environment: SQL Server 2005, Pervasive v8, Data Integrator, Microsoft Access 2003, PTE Financial, PRO Financial, Windows 2000.
Northrop Grumman Corporation (Richmond, VA) Jan 2007 – July2007
SQL Server Developer/DBA
VA Tax is in the process of designing, developing and implementing an Intranet system. The Intranet is a system comprised of multiple applications like Feedback server and internal web sites designed by and for Tax employees. As the senior Data Base Administrator I installed and configured the OS on hardware that housed each SQL Server in a clustered environment. I installed and configured SQL Server and established connectivity to the SAN, the front end being SharePoint server.
Responsibilities:
• Modeling and architecture of the SQL Server 2005 database.
• Created Windows Server 2003 and SQL Server 2005 Cluster.
• Integrated data between SQL server, Feedback server and sharepoint server.
• Developed and implemented schemas and group strategies.
• Implemented user Training and provided technical support.
• Prepared proper capacity, backup and recovery plans.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• DBA activities like creating users, roles and granting and revoking privileges.
• Assigned full-fledged security for SQL Server 2005.
Environment: SQL Server 2005, SharePoint Server 2007, Microsoft Exchange 2003, InfoPath 2007, VM Ware, Windows 2003.
AGENCY INSURANCE (Plattsburgh, NY) Sept 2006 – Jan 2007
SQL Server Developer
Agency Insurance has years of investment and insurance experience. The project is all about integrating into a centralized database with dynamic design and user-friendly web application, to keep track of Direct Bill Payments and Commissions from various Clients across the nation. Process involves data entry and verification of Payments, Commissions, Journal Entry, Unpaid Policies verifications. The presentation layer was in Visual Basic and ASP and the back end was SQL Server. The application and the database were in two different servers.
Responsibilities:
• Currently working on upgrading to SQL Server 2005.
• Modeling and architecture of the SQL Server 2000 database.
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
• Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Configuring, tuning, and optimizing SQL Server 2000.
• Performance testing on stored procedures, indexes, and triggers.
• Data migration using bulk copy program and DTS From Oracle Databases and Flat files.
• Data Staging and Data Scrubbing.
• Performed low-level scripting, fixing of codes and software enhancement process.
• Creating views and stored procedures and optimizing them as required by front-end developers for easier implementation on web pages.
• Working on different environments and a key resource for deployment of modified objects to production environments.
• Creating DTS Packages for data import, export, scrubbing and scheduled jobs for backups.
• Job Monitoring and making sure all jobs run successfully every night and documented them using Microsoft Office Suit.
• Creating Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Developing Crystal Reports used to generate all daily, weekly, monthly and quarterly Reports including current status.
• Technical Analysis, Code Review, Implementation, 24 x 7 production support.
Environment: Windows 2000, MS SQL Server 2000, MS SQL Server 2005, Microsoft.NET, Crystal Reports, Oracle 8i/9i, Toad 7.6, MS Office Access 2003, MS Visio Pro 2002.
Liberty Mutual Group. (Boston, MA) Nov 2005 – Sep 2006
SQL Server Developer
Liberty Mutual group is one of the leading providers of auto, home and life insurance in the United States. As a consultant at Liberty Mutual for the Human Resource Management System (HRMS), part of an ERP (Enterprise Resource Planning), developed and helped Liberty to implement HRMS that is designed to handle the human resource activities for the organization. HRMS is a web based three-tier architecture system that 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:
• Completed the modeling and architecture of the SQL Server 2000 database.
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
• Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Configuring, tuning, and optimizing SQL Server 2000.
• Performance testing on stored procedures, indexes, and triggers.
• Data migration using bulk copy program and DTS.
• Used Microsoft Office for data integration.
• Helping the front-end application developers with their queries.
• Performing low-level scripting, fixing of codes and software enhancement process.
• Administrator tasks like managing users, roles, and profiles.
• Performed Database backups (operating system, flat file backups & export/import).
• Designed the Forms & created Reports using MS Access.
Environment: Windows 2000, MS SQL Server 2000, Microsoft Office Access 2003.
ENGELHARD CORPORATION (Iselin, NJ) Sep 2004 – Oct 2005
SQL Server Developer
Engelhard Corporation is a fast growing company in New Jersey that manipulates basic materials - typically minerals, mechanically and chemically, altering their size, shape, porosity and chemical characteristics to produce a wide range of functionality with important business uses. This project included creating production and marketing system, which included all customer information and all business transactions with the help of Infor ERP SyteLine.
Responsibilities:
• Developed stored procedures and triggers.
• Maintained business solutions using Infor’s ERP SyteLine.
• Optimized SQL queries for efficiency and the front end developer with their queries and procedures.
• Backing up master & system databases and restoring them when necessary. Supported production environment.
• Reporting on a weekly basis to the project manager.
• Determine the SQL Server Installation options. Install SQL Server Management tools using SQL Server Setup Program. Test the Installation of SQL Server.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Planned the Complete Backing up of Database and Restored the Database.
• Fine tuning of database objects and server.
• Job Monitoring and making sure all jobs ran successfully every night
• Configured Server for sending automatic mails to the respective people when a job is failed or succeed.
• Installed and configured Analysis service
• Moved the entire phase from the Staging to the Production.
Environment: Windows NT, Microsoft SQL Server 2000, Crystal Reports.
HSBC BANK (Buffalo, NY) Jan 2003 – Aug 2004
SQL Server DBA/Developer
HSBC is one of the largest banking and financial services organizations in the world. It is a fast growing banking institution across the United States and its current services are primarily based in New York State. I am a senior team member in developing a Customer Information System project. Worked on various projects like maintaining customer information in order to make any decisions like loan approvals etc. Back-end work included writing and modifying Stored Procedures and Triggers.
Responsibilities:
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
• Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Configuring, tuning, and optimizing SQL Server 2000.
• Involved in requirement gathering, analysis, design, development, change management, deployment and user training.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Designed and analyzed databases.
• Login and User Management: Adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures.
• Scheduling Jobs and Alerting using SQL Server Agent.
• Proactive and Reactive tuning of databases in every stage of the project.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Involved in System testing.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
Environment: Windows NT, Microsoft SQL Server 2000, Microsoft Excel, SQL Query Analyzer, Crystal Reports.
ICICI Bank Ltd (Mumbai, India) Feb 2002 – Oct 2002
SQL Server DBA/Developer
ICICI Bank is India's second-largest bank with total assets of about US$ 38.5 billions. It provides all kinds of finance needs from securities to auto finance, banking, corporate and retail.
CMD Issue Collection Application was developed for Collection of Application money in respect of IPO/Bonds/Debt instruments by Capital Market Division (CMD) branch and other identified branches of ICICI Bank Ltd. The software application facilitated data entry for generating various Reports.
Responsibilities:
• Logical and Physical design of database for projects on basis of user requirements using ERWIN.
• Created/reallocated database objects on appropriate File groups to ease maintenance and improve data access performance.
• Coded Stored Procedures, functions and triggers at High level.
• Fine Tuned the SQL queries using hints for maximum efficiency and performance.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Participated in User Acceptance Testing (UAT) for different modules.
• Implementing user Training and providing technical support.
• Prepared proper backup and recovery plans.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• DBA activities like creating users, roles and granting and revoking privileges.
• Merging data into a single server for achieving better control, consistency & security of data.
ENVIRONMENT:
WINDOWS 2000, MS SQL SERVER 2000, SQL, T-SQL, SQL QUERY ANALYZER, PROFILER
Contact this candidate