| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name 1Address:Street Address Welbeck PlSt Johns, Florida, Street Address
Phone:PHONE NUMBER AVAILABLE (cell)Email:EMAIL AVAILABLETECHNICAL SUMMARY:MS Certified Lead SQL Server DBA/developer with over 25 years IT experience, including more than 22 years as a SQL Server DBA specializing in the full life cycle of administration, system analysis, design, development, and testing of application software with main role being in Lead Database Administration for on-premise, Azure and AWS across multiple servers in Stand-alone, Clustered (Windows and Always On) and Serverless environments.TECHNICALQUALIFICATIONS:Operating Systems:Windows 2000 up to Windows 2022, MVS/ESA, Ubuntu, Sun Solaris 9, VMware ESX servers.Cloud Environment:AWS, Azure, Private VMWare FarmServer Administration:MS SQL Server 2000 up to 2022,, Azure SQL, Azure Managed Instance, AWS RDS, PostgreSQL, DB2, Oracle, MS AccessSQL Server Specific:DTS, SSIS, SSRS, SSAS, Azure Data Lake, Polybase, Crystal Reports, Bird on Cloud BI tool, Dynatrace etc.Other Tools:Data Domain, SafeNet Gemalto, Lite Speed, Apex SQL Audit, Spot light, Blade Logic, Altiris, BMC Remedy, Pro Task, CyberArc, OPAS, Notes, Jira Board, GDPR, PCI and HIPPA Compliance tools.EXPERIENCE:Optum (former ChangeHealthCare)Major US Pharmaceutical CompanyNov 2007 PresentLead Prod SQL DBA/DB ManagerJacksonville, FLLead and direct the team of 7 SQL Server DBAs (onshore and offshore) on maintaining various databases (~1400 in total; largest is ~40TB in size) on production/QA/development servers (300+ servers) in AWS, Azure and Private Cloud environments and provide 24/7 Production support of all databases and round-the-clock database operations.Lead and implement project of consolidating and virtualizing of various companywide servers under couple of VMWARE dedicated cluster, Azure Reserve Instances and AWS Dedicated Host. This project saves company millions of dollars on MS license and support cost.Fully Responsible for all corporate-wide SQL Server database administration and control Lead all aspects of database administration and design for the applications development and Business Unit teams, including data modeling, backups, replication, mirroring and AlwaysOn.Design and implement a corporate DB disaster recovery plan utilizing Azure Site Recovery, SQL Always On, DB mirroring, SQL replication (snapshot and transactional), log shipment and hardware replication tools.Design, develop, test and document thousands of T-SQL stored procedures, functions, triggers, SQL Reports, SSAS cubes, SSIS packages and jobs for enterprise company websites and products.Troubleshoot and fix thousands of t-sql performance related issues.Work on several SQL Server consolidation and migration projects from older SQL versions to SQL Server 2019/SQL 2022Enforce and Control Change, Security Management, best practices, standards for all DB related activities.Implement company wise SQL Server Monitoring using Idera, SQL Sentry and Quest Foglight monitoring tools.Extensive experience in Capacity planning, Performance Tuning, DR,, backup and restore procedures.Documented disaster recovery plans and participated disaster recovery drills.Experience in investigating and applying necessary SQL Server database patches and installing service packs.Candidate's Name 2Ceva Logistics (former TNT Logistics)Leading Global Logistics companyJun 2005 Nov 2007Senior SQL Server Database AdministratorJacksonville, FLFully responsible for more than 100 corporate databases with the largest one ~800 GB.Developed, designed and documented tables, view, stored procedures, advanced queries, triggers, indexes and functions..Performed multi-layered SQL Server optimization, capacity planning, DBCCs, script debugging, task automation, code review, code promotion. Plan, specify and deploy new hardware into several 24x7 production Windows 2012/2016 Active-Active cluster environments.Authorized and implemented several scaling out processes on main corporate database to improve overall database performance and scalability.Developed an archiving process for several production databases that moves archived data nightly to a dedicated server, reducing production database size and increasing performance.Designed and implemented process of migrating companys databases from SQL 2008 to SQL2016/SQL2017.Authorized and designed multiple complex MS SQL SSIS packages. Reviewed, evaluated, designed and implemented strategies for data acquisitions from numerous file layouts and media forms into a single, comprehensive SQL Server database. Responsible for creating data extracts and developing reports as needed. Developed database load routines to match numerous diverse file layouts and ensure accuracy of data.Monitored and troubleshoot database time-out reports utilizing internally written software called Enterprise Watch and Veritas Indepth 3.1Participated in design stage of corporate datawarehouse by Extracting, transforming and loading data into the multiple Datamarts.Implemented and maintained policies, procedures and standards to ensure security and integrity of test and production data. Provided data flow diagrams as documentation, Responsible for leading complex projects; ensure adherence to Corporate Technology Project Standard Practices. Performed on-call duties and system implementations and upgrades that occur after normal business hours and weekends as required to minimize business impactAdministered multiple Oracle 11G databases of third-party applications designed by I2.Procurestaff (subsidiary of VOLT Information Science)Human Capital Management e-procurement technologies and managed service deliveryMar 2002 Jun 2005Senior SQL Server Database AdministratorNew York, NYFully responsible for more then 140 corporate databases with the largest one ~80GBLeaded all aspects of database administration and design for the applications development teams, including data modeling, backups, replication, log shipping and recovery. Design and implement a disaster recovery plan.Performed SQL Server optimization, capacity planning, DBCCs, script debugging, task automation, code review, code promotion. Plan, specify and deploy new hardware into the 24x7 production Win 2012 Active-Active cluster environments.Created and managed multiple recurring production data import/export processes into MS SQL databases to be readily accessible by reporting teams and sales representatives.Improved query response times by re-designed index architecture and tuning complex queries, such as correlated sub queries, multi table joins and conditional logic.Tuned SQL Server parameters with databases residing on a clustered SAN to manage enterprise data flows.Designed and built data archiving process for a yearly movement of 1+ billion rows using SQL-DMO, DTS Object Model with COM/COM+ components.Built stored procedures to monitor hanged SQL Server jobs and excessive blocking, alerting users via email.Designed, developed, tested and documented hundreds of T-SQL stored procedures, functions, triggers, DTS packages and jobs for enterprise company websites and products.Continual review of SQL (consideration of memory, CPU, I/O, locks and indexes) that negatively impact query-processing time.Candidate's Name 3Created various NetIQ knowledge base scripts to monitor major SQL Server and Windows activities at Production SQL Cluster boxes and IIS servers.Amended MS SQL server security roles and accounts on multiple servers to limit user access and secure data.Created and managed multiple recurring production data import/export processes into MS SQL databases to be readily accessible by reporting teams and sales representatives.Trained and assisted application programmers in effective database development techniques. Provide after-hours training seminars teaching standard and advanced SQL Server programming.Forest Laboratories MIS Production SupportPharmaceutical CompanyNov 2001 Mar 2002SQL Server Database AdministratorHauppauge, NYImplemented database back-up procedures, maintenance plans, pro-active alerts and for multiple SQL Server 2000 and Oracle 8i databases. Tuned and identified performance problems with growing 30+ GB databases.Administered and maintained 8 SQL Server servers running on Windows 2000 Cluster advanced servers.Fully responsible for mission-critical 24/7-production databases.Migrated multiple reporting databases from MS Access to MS SQL Server 2000, increasing performance and availability.PricewaterhouseCoopers LLP Management Consulting Services (MCS)Professional Services CompanyDec 1997 Nov 2001MCS Consultant / Senior AssociateNew York, NYClient:Major League BaseballNew York, NYApr 2000 - Nov 2001Participated in full Lifecycle production (design/development/implementation/testing) of thin client modules of Baseball Information System utilizing Microsoft's Active Server Pages, Visual Basic 6, DCom/Com/MTS, IIS5, XML/XSL/XSLT, Crystal Reports on front-end and MS SQL 2000 and MS Access on back-end.Formulated the technical design, System Documentation Specifications, logical and physical database design of Scouting Laptop, Scouting Web and Minor League Contracts Information Systems.Designed and implemented complex data transformation processes using VB, MS Access and MS SQL.Performed all aspect of administering of SQL Server via Enterprise Manager and Transact-SQL.Authorized and designed multiple complex MS SQL DTS packages, Link Servers.Assisted in writing and execution of system and integration test scenarios of designed modules.Client:Bristol-Myers SquibbPrinceton, NJAug 1999 - Apr 2000Developed the Manager and Employee Self-Service Web sites for BMS Human Resource Department by integrating Active Server Pages, Visual Basic and Plumtree Portal with back-end MS SQL Server and SAP DB.Developed SAP BAPI objects and called them from the Active Server Pages using SAP DCom.Created functional storyboard through the conducting interviews with the clients.Client:Schering PloughUnion, NJJan 1999 - Aug 1999Authored and designed Oracle database driven Intranet Web site for Strategic Marketing Department using Active Server Pages, Visual Basic and Oracle.Created Oracle packages, stored procedures, functions and triggers for maximizing the speed and efficiency of Intranet application.Client:Prudential HealthCareRoseland, NJMar 1998 - Jan 1999Developed A/R tracking application using Active Server Pages, Visual Basic and SQL Server and MS Access.Provided follow-up training for clients on the use and maintenance of the A/R system.EDUCATION:Pace UniversityNew York, NYDec 1997Bachelor of Business Administration in MIS, QPA 3.5Bachelor of Business Administration in Public Accounting, QPA 3.4 |
