| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Phone: PHONE NUMBER AVAILABLE Email: EMAIL AVAILABLEProfile:Experienced SQL Server Administrator/Developer with over 37 years in IT, specializing in SQL Server DBA, EPIC Cogito Admin, DW/BI initiatives for the last 20 years. Skilled in managing over 200 SQL Servers, ensuring database integrity, and setting up Always On over 3 node failover clusters for HA/DR. Adept at troubleshooting, performance optimization, and overseeing daily ETL maintenance for large-scale Clarity and Caboodle databases. Proficient in using SSIS, Informatica for ETL, SSRS/SSAS, Power BI for report deployment, and effectively translating business needs into technical designs. Skilled at leading teams to deliver comprehensive solutions and providing technical guidance for complex business initiatives.Employment History:SQL Server Admin / Clarity/Caboodle (Cogito) Admin - Guthrie, Sayre, PASeptember 2021 CurrentManage over 200 SQL Servers, on-prem and Azure, supporting internal and external applications.Ensure database integrity, index management, backups, recovery, capacity planning, security.Monitor server performance, troubleshooting issues, and optimize as needed.Ensure all the servers have the latest patches OS and SQL within a couple of weeks of release.Setup Always On over a 3 node failover clusters in 2 geographical locations to provide HA and DR. I setup a 2016, 2017 and 2019 cluster to applications. Consolidated 50 application / servers were consolidates to the clusters.Setup custom imports/exports from vendors. Utilize SSIS, Powershell, batch jobs and sqlcmd to automateSetup SQL Server reporting services and trained report writes to utilize SSRS and Power BI to replace Crystal, Qlik.We made several modifications to Caboodle while ensuring confirmed dimensions integrity of the data warehouse. Developed of additional DMCs, testing for functionality and performance and promoting to production.Administer Epic Cogito including regular upgrades - Clarity / Caboodle / SlicerDicer / BI Restful server, Cubes and monitoring server activities, providing comparison reports, Nova notes and Sherlock ticketsSQL Server Admin / Clarity/Caboodle (Cogito) Consultant - Advocate Aurora HealthMarch 2021 September 2021Review daily ETL executions, address errors/warnings and manage Sherlock and Nova ticketsContribute to clean up of validation errors, both metadata and ETL and implement for changes in EPIC environments.Create DMCA for report writers to handle impacted reports due to ETL warnings.Perform index maintenance, analyze, and working on partitioning tables for 20TB Clarity database and 8TB Caboodle databasesMake several SQL Server settings to maximize workload, monitor SQL Agent jobs and optimize SSIS jobs.SQL Server Admin / Clarity/Caboodle (Cogito) Consultant CHSLI Catholic Health Systems of Long IslandAugust 2019 March 2021Oversee Clarity operations, including daily ETL maintenance, timely application of Ras, Compass upgrades, and collaboration with end users and analysts.Manage caboodle operations, ensuring smooth daily ETL, handling upgrades, and optimizing performance with report analysts, dealing with work queues, error logsServe as SQL Server DBA, addressing daily operations, identifying bottlenecks and executing the Upgrade from SQL 2016 to 2017.Implement ACG for the Healthy Planet team to enhance care management efficiency.Collaborate with the Human team to enhance care management efficiency through ACG ImplementationDatabase Operations Manager at a Hedge FundFeb 2019 August 2019Lead a team of 6 DBAs to manage operational aspects of over 600 servers.Provide technical guidance for large and complex business initiativesMentor junior DBAs to enhance their skills.Implement new releases upgrades, and optimize new features for application usersEnsure optimal performance and high availability meeting high service levels.Performance tuning efforts where we have been engaged or proactively as we get alerts.Work on additional projects upgrade to 2017, utilizing Always on across the fleet, SQL True up etc.Utilize automation tools to expedite daily operations.Sr. SQL Server DBA, Cogito, Clarity, Caboodle Admin - MontefioreOct 2014 January 2019Install, review, and maintain Clarity operations on Oracle Exadata, including applying RAs, upgrading from EPIC 2014 to 2018, and creating derived tables for performance optimization.Monitor and troubleshoot Clarity ETL, reviewing errors, running fix jobs, extracting tables and updating performance stats on Oracle.Install, review and maintain Caboodle operations on SQL Server, including upgrading from version 8.2 to 16.11, developing custom DMC, and setting up HA/DR and maintaining security to ensure HIPAA compliance.Administer SQL Server, focusing on performance tuning, query optimization, index management, manage EPIC delivered cubes, customizing cubes for financial, BPA, and Pharmacy, and apply customizations to newly delivered cubes during upgrades.Reviewing Nova notes, change logs,Troubleshooting performance issues by reviewing AWR reports on Oracle, updating stats as neededSr. SQL Server DBA Subway FWH, Milford, CTDecember 2013 September 2014Manage over 40 Production and 60 Development server, providing and collaborating colleagues to resolve database incidents and request within SLAs.Focus on performance tuning, Query Optimization, analyzing query plans to identify and address bottlenecks using various monitoring and troubleshooting tools - Performance Monitor, SQL Profiler, Idera,Troubleshoot and resolve database integrity issues, performance problems such as blocking and deadlocking, replication, log shipping, and other security concerns.Utilize DMVs to detect and troubleshoot SQL Server related resource contention - CPU, Memory, I/O, disk space.Managing Partitioned on very large tables that were causing long IOs and other performance issues.Setup database backups, restores, recovery models, replication, log shipping DR plan and operational automation while ensuring proper index management techniques and documentation of process and procedures.Created TSQL code - stored procedures, triggers, functions, tables, views, indexed views, indexes, constraints.SQL Server DBA Team Lead Custom Vault, Inc., Bethel, CTAugust 2011 November 2013Managed SQL Server infrastructure, including installing new servers, patching and transferring databases.Oversaw database backups, replication, log shipping, setup of alerts for space, security, automate integrity checks, index rebuild/reorgs.Conducted Performance Tuning, Query Optimization, analyze query plans to provide solutions. Utilize Perfmon, Sysmon, SQL Profiler along with DMVs to detect and troubleshoot and fix issues.Provide SQL database operational support to tech users, developers, developed run books.Designed dimensional star schema models and utilized SSIS to populate them from the operational systemPublished several SSRS reports using data marts and reporting data warehouse to create standard parameterized reports with drill down, drill thru and drill across capabilities.SQL Server DBA LLS, White Plains, NYAugust 2008 July 2011Install and maintain production, dev, test and staging environments for SQL Server 2000/2005/2008 as well as Oracle 10G, providing 24x 7 supportTroubleshoot database issues, identify problem queries and perform performance tuning, using DMVs to analyze and query plans and resolve blocking and deadlocking.Implement High availability and disaster recovery solutions using clusters, replication, log shipping, and utilized tools like Quest Spotlight, Litespeed, Capacity manager, Foglight and Redgate software.Setup database maintenance plan for backups, full and transactional log, and provide support for SQL Developers by creating stored procedures, triggers, functions, views, indexed views, indexes, constraints.Act as the data architect, gathering requirements, creating data models, and making model changes along with creating scripts for tables, constraints, indexes, primary keys etc.Principal Consultant Hologic (Cytyc Corporation), Marlboro, MAAugust 2007 August 2008Administered multiple databases, performed maintenance plans, and installed software for post-market quality system.Designed and implemented SQL Server database and web-based complaint data application,Managed virtual servers, transferred data from MS Access using SSIS, and transitioned complaint handling system to a validated workflow paradigm.Utilized SSIS to create a data warehouse based on a dimensional model to feed the different reports/analysis.Utilized SSRS to meet reporting requirements utilizing sophisticated visualization, using cascading prompts and complex T-SQL using dynamic temp tables.Utilized SSAS to facilitate analysis of their complaint data OLAP cubes using SSASData Warehouse Analyst / DBA Covidien / US Surgical, Norwalk, CTMay 2003 August 2007Administered SQL Server (2000/2005) database for data warehouse initiatives, including development, maintenance and enhancing business intelligence applications with ETL tools, Oracle SQL scripts, automated batch jobs on UNIX and Cognos TransformerArchitected the data warehouse environment on an SQL Server / Oracle Server integrating feeds from SAP (IDOCs as well as replicated tables), other Oracle / SQL Server systems, XML, flat files, into the star schema dimensional model utilizing SQL Server 2000 DTS packages and later SSIS as ETL tools.Manage all aspects of maintaining the SQL Servers including installation, patch upgrades, operational backups/ restores / setting up maintenance plans, monitoring and performance tuning.Collaborated with user groups to identify reporting requirements, created data marts, created SSRS reports for various systems used by Manufacturing and QA/QC departmentsCreated several OLAP cubes for servicing the Sales and Marketing department, to analyze sales performance against quota. Analysis was also made available for new product launches, events, by group purchasing organizations as well as several other dimensions.Principal Consultant IMany, Inc., Portland, MEMay 2000 April 2003Led end-user interviews and requirement sessions, performed business function and data analysis to produce detailed design specifications.Modeled data warehouses following Kimballs methodology, utilizing ERWIN and ER Studio to create Dimensional models and reverse engineering from existing databases.Implemented ETL solutions using Informatica PowerCenter, /PowerMart, Cognos Decision Stream, Import, Export utilities specific to the database such as SQL Loader, DTS packages to do Data extractions from various legacy applications.Documented target to source mappings, created tables, analyzed the mappings, did SQL performance tuning, index analysis on tables and further maintained detailed metadata information based on information gathered from end-users, developers, DBAs and other data modelers.Utilize several reporting tools such as Cognos PowerPlay, Impromptu Web Reports (IWR) and Crystal Enterprise Reports to create reports based on specifications.Utilize various OLAP tools including SSAS and excel to create reports to deliver functionality to users.Monitoring queries and report behavior to assure expectations are met.Create Test plans for unit testing, system testing and user acceptance testing, ensure data quality and troubleshoot production problems as necessary.Also, assisting the project manager in creating project plans, tracking milestones and coaching / mentoring other developers.Software Engg. Swiss Re, Reuters, Pepsi, UltraSeal, Simple Software, Tata UnisysMay 1986 April 2000I was responsible for various projects including redesign of several applications, merger conversion and integration of applications, Y2K and maintenance of the front-end systems.Analyze, document, design and develop front-end application that need to be re-engineered into client server, windows based as well as web-based applications from older legacy-based systems to improve performance and functionality using PB, VB, ASP, Informix and Oracle.Responsible for several of data conversion projects involved in merger between Swiss Re / Life Re including understanding the application architecture/data structures of both systems. Created the specifications for input from Life Re and mapping to Swiss Re systems.Responsible for identifying, documenting and modifying of the front-end applications that were affected by the mergers of the systems and Y2K changes.Other activities include monitoring progress of different projects, creating project plans, tracking milestones and coaching/mentoring other developers. Also perform UNIX systems administration as needed, maintain/create shell scripts, and Informix DBA activities on the dev system, optimizing SQL and monitoring the UNIX systems.- Automated several of their production, accounting, inventory and QC/QA operations.Designed, wrote, implemented many applications including daily profit and loss / Costing system, Job Scheduling, Inventory Control, Sales Quotations, Summary Consumption reports, Sample retention, archival and retrieval systemsResponsibilities included development of in-house accounting and Point-Of-Sale systems.Wrote general purpose business software such as checkbook management, personal planner, sales lead tracking system, inventory control, payroll, invoicing for our mail order business in Clarion.Analyzed, designed and implemented and maintained custom business packages for our clients using dBase / FoxPro and Clarion.I was the lead programmer and systems analyst along with 2 other developers.I also started going part-time for my masters program in Computer Science, while working here, which I finished in two years from 1990-1992.Maintenance of Airline systems including Airline Reservation, Cargo management, Airline Revenue.Skills:SQL Server DBAPerformance OptimizationAlways On Failover ClustersSSIS, Informatica for ETLSSRS/SSAS/Power BI, Crystal Reports for ReportingEPIC Cogito Administration / DevelopmentTechnical LeadershipEducation:Master of Science in Computer Science, SUNY, New PaltzMay 1992Batchelor of Science in Chemical Engg., IIT DelhiMay 1986 |
