SUMMARY OF QUALIFICATIONS

• Production SQL Database Lead/Administrator with over 17 years of IT experience including Database Design, Administration, and ETL implementations
• Proficient in SQL Server, SAP Data Integrator, and Java
• Participated in projects at all stages of SDLC including planning, requirement analysis, design, development, integration, testing, deployment and operational support
• Worked in teams as development DBA with a single company product as well as a production DBA supporting SQL Server farms leading a support team of 7 people
• Successfully delivered to SQL 2008 and SQL 2012 upgrades, real-time ERP-to-ERP replication, data duplication and cleanup projects leveraging offshore teams and SCRUM methodology
• Self-starter, have strong troubleshooting and analytical skills, paying attention to details, can work without supervision and clearly defined directions to meet important deadlines

Technical Skills

PROFESSIONAL EXPERIENCE

Confidential

SQL DBA Architect

• Weiss Residential Research develops a proprietary technology that optimizes housing market decisions. Weiss' technology calculates property specific price indexes for over 45 million homes. WRR analytics improves investment decisions, portfolio management and modeling engines. The analytics are produced through the use of Big Data techniques, novel algorithms and by harnessing massively parallel computing power.
• Migrate database from MySQL to SQL Server 2014
• Re-design schema for scalable parallel processing
• Installation of SQL Server 2014, Setup backup and disaster recovery via log shipping , alerts
• Optimization of existing processes queries and SSIS packages

Environment: SQL Server 2014, Azure

Confidential

Lead SQL DBA

• Liaison provides admissions management solutions to higher education. It powers the most admired admissions offices with its centralized application service, provided to universities through professional associations, and its unicas product, provided directly to universities.
• Lead a DBA team remote members in India and Canada
• Make sure all administration tasks are implemented on time backups, optimization
• Troubleshoot application and data transfer SSIS issues
• Implement tools for process automation and self-service using Red Gate and DBMaster tools
• Work with management, infrastructure, support, and development teams
• Troubleshooting and implementation of sql server transactional replication SQL 2005 and clustering 2012
• Planning and implementation of upgrade to SQL 2012
• Optimization of view, stored procedures, and ORM queries
• Monitor of the database systems using Red Gate monitor
• Participate in business projects to deliver new application solutions
• Implement change management and best practice monitoring

Environment: SQL Server, Red Gate, DBMaster, SSIS

Confidential

Team Leader, SQL DBA

• Movado SFA sales force automation allows users to download data from SAP about customers contacts, credits, order and billing history , company products, pricing and availability. Once data downloaded Sales Representatives can use the application offline and without VPN connection to take an inventory, calculate sell-thru, generate and print orders. SFA application will use EDI to automatically submit orders to ERP.
• Responsible for analysis of original application written in Visual Basic algorithms and data model .
• Owned data model, worked with development, business analysis teams on the application data model.
• Installed and managed SQL server.
• Optimized database using multiple data files, server settings, indexes as well as changing SQL queries.
• Extracted historical and incremental master and transactional data including customers, materials, pricing, sales, and billing from SAP ECC and BW into Microsoft SQL database utilizing BODI XI and SQL server stored procedures.
• Wrote project-related documentation

Environment: SAP Data Services, SQL Server, Java, Hibernate, VBA.

Confidential

Production SQL DBA

• PerformCare is a complete behavioral health care and human services company that supports over 4 million members in the public and private sectors. PerformCare specializes in providing superior, innovative solutions to support behavioral health, human services, and integrated health programs that are outcomes-focused and customized for: Medicaid and Medicare Plans, Commercial Health Plans, Wellness, Employee Assistance, and Specialty Products
• Reviewed existing SQL server landscape.
• Proposed multiple options to implement disaster recovery and fixed SQL server replication in production.
• Reviewed and fixed multiple issues in security replaced authentication to integrated .
• Implemented HA and DR using mirroring and log shipment cheaper option than cluster .
• Setup monitoring jobs and alters drive space, mirroring and log shipment issues, jobs failures .
• Worked with development team in identifying and fixing queries, stored procedures using SQL Profiler.
• Helped in creating the missing indexes and statistics in various tables as part of the performance tuning, optimizing .net application to make mirroring and log shipment more efficient.
• Created test and development environment culture, assisted in change management setup.
• Helped to go through SQL server audit data had personal health information .
• Fixed SSIS packages to use configuration parameters instead of hardcoded server names.
• Provided 24/7 on-call support for production support.

Environment: SQL Server, SSIS, SSRS.

Confidential

• Database Modeler/Integration Consultant
• Owned data model, worked with development, ETL, business analysis teams on model.
• Implemented integration with database encryption tool for PCI compliance.
• Worked with technical advisors on conceptual model and integration with 3rd party applications.
• Worked with architects to make web services compliant with Enterprise SOA Standards.
• Managed integration with Data Cleansing Software customer deduplication, addresses .
• Managed an offshore development team 8 developers using 2-week agile iteration.
• Designed integration with MapQuest for hotel radius search.
• Contributed into continuous integration setup and build automation.
• Participated in demo preparation for every iteration.

Environment: Oracle, ERWIN, Excel, Enterprise Architect, Eclipse, Hibernate Tools, Git, SVN, Maven, Hudson, Google sites, Mingle, Map Quest API, Web services, SOA, Hibernate, Spring, CXF, Checkstyle, PMD, oberture, MQ Series.

Confidential

Production DBA Team Lead

• Supported retail and business intelligence applications including OLAP cubes, worked on migration of multiple legacy applications to SAP platform leveraging an offshore team.
• Supported production and pre-production databases. Environment included 21 servers in 3 time zones EST, Switzerland, and Hong Kong , 459 database instances in compatibility modes from 6.5 to 2005. 33 applications used 226 unique databases with total size more than 1Tb. Most production servers were hosted by Windows Server 2003 64 bits with RAID5/10 over SAN, and test/dev servers were based on enterprise VMWare products.
• Coordinated major upgrades and troubleshooted operational issues with application owners and software vendors.
• Worked with IT team on hardware issues, communication channels problems, and hardware requirements.
• Supported retails cubes critical to the business.
• Monitored daily synchronization with company boutiques and cube updates.
• Troubleshooted OLAP design performance issues.
• Developed software/hardware inventory application based on MS Analysis Services and SQL Server, Excel, Java technologies to collect statistics that allowed analyzing the company's software and hardware environment in real time. The application reduced time required to support requests by 15 , helped to work in unknown environment to figure out relationships between applications, databases, and people.
• Tuned SQL server performance, troubleshooting and real-time monitoring of internal processes SQL server jobs, windows tasks, real-time replication, custom downloads, SSIS packages basing on Microsoft Operational Manager 2005 notifications.
• Completed migration from SQL 2000 to SQL 2005.
• Implemented of data replication from SAP R/3 into legacy database schema in order to support legacy applications 10 during transition period 2-3 years .
• tool evaluation open source and commercial ,
• research targeting possible replication architectures real-time replication versus scheduled downloads
• made proof of a concept for several most important master and transactional tables, took online classes, spent a week with a consultant provided by Business Objects.
• developed project plan development, coordination with application owners and offshore team, troubleshoot implementation issues.
• created a tool to generate mappings basing on metadata files which speed up implementation for one table by 70 .

Environment: MS SQL 2005 including DTS, SSIS, SSAS, SSRS , Orion Integrator, Microsoft Remote Desktop, Microsoft Operations Manager, Excel, SAP R/3, Business Objects Data Integrator, Microsoft Project, Sybase, DB2/AS400

Confidential

Development DBA

• PML Promotion Merchandising Layout. SAP PML for Retail provides retailers with an effective advertising, marketing, and promotions tool that streamlines the process of selecting and presenting products and promotions within printed and electronic promotional collateral. Electronic merchandising layout and merchant-centric asset management functionality enable the merchandising organization to create more targeted and timely promotions while improving productivity and efficiency. SAP PML enables the merchant or merchandising assistant to create and maintain a database of offers and easily plug them into an electronic merchandising layout that is linked into a desktop publishing program that the advertising team uses to create the final piece of collateral.
• Participated in project initial knowledge transfer on wide variety of proprietary concepts frameworks, such as logging, security, persistence, user management.
• Managed all processes related to database administration including software installations for development and QA environments, backups, data modeling, DTS, job creation and scheduling, index tuning.
• Prepared initial database scripts.
• Synchronized SQL changes made between the development and production environments.

Environment: SQL Server 2005 SSIS , Eclipse, Delphi 2006, Araxis Merge, Ant, SSH, Oracle, Mediagrif Open Server

Confidential

Database Developer

• Blue Edge - an agent portal. Independent insurance agents and internal sellers use BlueEdge to develop quotes to present to individual and small group applicants. They can also use BlueEdge to track the status of applications within the underwriting process. BlueEdge also serves as a reference repository, where agents can go to find documentation, paper application forms, etc.
• Worked as a database developer on multiple projects: Member Touchpoint Measures, Blue Avenue, Blue Edge , Tribal Portal, Data Scrubbing.
• Designed an approach to copy related tables basing on foreign key dependencies and decoupling.
• Developed a program to determine natural keys in tables basing on existing data and a program to create transformations for Kettle tool automatically.
• Copied data related only to 100 customers stored in more than 50 tables from one schema to another with traceability to original records.
• Replaced private health information with generated information.
• Resolved assigned tickets from database team queue.
• Created SSIS packages for archiving data and Data Migration and complex TSQL stored procedures and views for reporting purposes.

Environment: SQL Server, SSIS, Oracle, Kettle, Eclipse, Java, yEd.

Confidential

Development Database DBA/Developer

• SAP xApps Product Definition SAP xPD - a tool for companies focused on Product and Service Innovations. xPD covers the first phase of the product development lifecycle ranging from idea generation to the detailed definition of a concept for products or services.
• Managed databases installation, security, patching, optimization and associated documentation.
• Managed database objects stored procedures, views to ensure required performance including indexing, query optimization, data partitioning, database/table options.
• Implemented CAF Security framework using rules approach, integration between xPD and xRPM using web services, several xPD and CAF UI reusable components, integration with xRPM and cProject via JCO client.
• Developed integration with user management framework UME 4.0 .
• Documented development guidelines, code convention, HOW-TO articles.
• Proposed performance UME 4.0 improvements.

Environment: SQL Server 2000, SAPDB, SAP NetWeaver, SAP GUI, SAP xApps J2EE, DTR, CBS, Web Services

Confidential

Java Lead Developer

• IMIS online - a system that assists new owners with managing the assets and personnel of the insolvent companies and helps in organization of web auctions on insolvent companies' assets. The project was developed for a German customer. BE.N UNITY web application provides major services an insolvency manager or company may need.
• Designed and implemented asset import mechanism.
• Designed and implemented customer communication tools forum, faqs, billboards .
• Worked on performance optimization of services build using EJB.

Environment: SQL Server 2000, WebSphere, Rational Rose, Idea, Clear Case, J2EE, EJB, Servlets, XML, JSP

Confidential

Java Developer

• Insight Runner - a tool for a wide range of programming competitions and labs on algorithm related theories. It is also used in remote education classes and for supervised education.
• The purpose of the project was built around two main concepts - task and solution. Task represents a computation problem usually with algorithmic nature that can be solved with a program written on any programming language. Tasks are suggested for a group of students within a contest or a long term course. The system provides automatic evaluation of the submitted solution and collaboration tools.
• Managed 5 developers.
• Implemented several functional modules using Java and C languages
• Worked on performance optimization using OptimizeIt.
• Monitored and resolved troubles in production environment.
• Provided teachers and students with user training and day-to-day support.

Environment: MS Project, SQL Server 2000, JIRA, Rational Rose, J2EE, JavaMail, XML, FreeMarker, Velocity, JSP, OptimizeIt