Sql Server Azure Data
Resume:
Samuel J. Mike
Fort Myers, Florida 33967
email: **********@*****.***
Linkedin: linkedin.com/in/samuel-mike
Recent Professional Summary:
●Hands - on experience in Azure Cloud Services (PaaS & laaS), Azure Synapse Analytics, SQL Azure, Data Factory, and other Azure Stack Modules/Services
●Analysis services, Application Insights, Azure Monitoring, Key Vault, Azure Data Lake .
●Database design & architecture; Azure, SQL / Azure Data Warehouse
●Strong experience in implementing High Availability & Disaster Recovery solutions using Always ON, Clustering, Replication, Mirroring and Log Shipping
●Good knowledge & experience on Cloud Computing like Azure AWS/Azure
●Experience in designing ETL for data movement between excel, flat file, RDBMS like Oracle, DB2 and SQL Server using Bulk Insert, BCP utility, DTS and a variety of SSIS(ispac) packages including custom transformations for a wide range of business requirements
●Troubleshooting, Optimization and Performance tuning of SQL Server database server (Ex., Query Tuning, Server Tuning, Disk Performance Monitoring, Memory Pressure, CPU bottleneck etc.)
●Worked in OLTP & OLAP environment that includes Production (24x7), QA and development databases in SQL Server.
●Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
●Extensive experience in T-SQL to write: stored procedures, triggers, functions, tables, views, indexes and relational database models.
●Experience in Installation, configuration and maintenance of SQL Server.
●Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
●IT consulting Experience including handling of roles like Software Developer
●Managed Application Lifecycle Management (ALM) Architect, Confidential Architect, Application Performance Architect & Developer.
PROFESSIONAL EXPERIENCE
SENIOR DBA: Avetech Solutions, State of Texas - Remote (June 2022 Present) Consultation for State Of Texas.
●Involved in the full life cycle of software design process of other projects, including prototyping, proof of concepts, design, interface implementation, testing and maintenance.
●Designed and Configured Azure Cloud relational servers and databases analyzing current and future business requirements
●Worked on migration of data from On-prem DB2 and SQL server to Cloud databases (Azure Synapse Analytics (DW) & Azure SQL DB).
●Designed, Tune, Trouble Shoot, and implement high availability SQL Server solutions, including HA/DR/ Always On, Log shipping, Mirroring, Replication and Clustering
●Design, support Data warehouse using Business Intelligence Technologies such as Data analysis, TSQL queries, ETL & ELT Process, Reporting Services (using SSRS, Power BI) and Analysis Services using SQL Server, 2005 / 2008/2012/2014/2016/2019 SSIS, SSRS and SSAS, SQL Server Agents.
●Monitoring SQL related incident tickets, change requests and service calls for 24/7 environments.
●Ensure data consistency in the database through DBCC,DMV, and other tools.
●Migrate data from legacy systems (Cobol/DB2) to the Azure SQL Environment
●Performance Tuning, Query Optimization, using Performance interactions with Microsoft.
●Worked as a project coordinator between IT and business users by converting business requirements to technical specifications and proposed feasible solutions.
●Create pipeline jobs, scheduling triggers, Mapping data flows using Azure Data Factory(V2) and using Key Vaults to store credentials.
●Create and maintain Elastic pool databases and schedule Elastic jobs for executing SQL procedures.
●Worked on creating tabular models on Azure analysis services for meeting business reporting requirements.
●Design and implement Azure BLOB and Data lake storage and loading data into Azure SQL Synapse analytics
●Provide business, data, application and technology consulting for IT team members and business partners.
●Provide technical leadership and guidance to the IT teams for project level architecture and design work.
●Review and approve project level architecture and designs for IT projects and create these artifacts as needed
●Coordinate communication and activities between technical teams and end user's.
●Design Enterprise strategy for Continuous Integration, Continuous Deployment and Continuous Testing
●Implement tools for Continuous Integration, Continuous Deployment and Continuous Testing.
● Provide business, data, application and technology consulting for IT team members and business partners.
●Provide technical leadership and guidance to the IT teams for project level architecture and design work.
●Review and approve project level architecture and designs for IT projects and create these artifacts as needed on large,
SENIOR DBA: Brooksource Services, Chicago Illinois - Remote (September 2022 - June 2022) Consultation for Exelon.
●Lead a team of database administrators migrating from Oracle business suite on AWS infrastructure to Azure
●Performed database troubleshooting, management, backup, restore and routine maintenance DBCC,
Re-index of database table indexes, database performance tuning.
●Managed Users, Roles, Principals and Securable Administration to access the databases at various
levels to provide better security on both SQL Server and Windows Authentication Modes.
●Monitored database status including CPU, memory, I/O, space, and deadlock using SolarWinds, Foglight, SQL Sentry SQL Server and other utilities.
Utilities.
●Developed SSIS and SSAS packages in SQL Server using Business Intelligence Studio and created jobs to schedule the SSIS and SSAS packages in SQL Scheduler.
●Designed and Lead day-to-day operations of the data bricks, data lakes, snowflake, mongo DB and various other no SQL databases
●Assist in the overall architecture of the Azure Data Vault utilizing Data Vault 2.0 best practices.
●Interpreted business requirements and provided input from a data perspective.
●Built simple to complex pipelines and dataflows.
●Built reliable, scalable distributed systems for data analytics and reporting.
●Performance Tuning, Query Optimization, using Performance interactions with Microsoft.
●Designed and administered Kubernates environment.
●Trained IT teams on finding bottlenecks and interpreting the results.
●Performance Test Management and Coordination with all IT teams.
SENIOR DBA: TCGPLAYER, Syracuse Illinois (September 2021 - September 2022 )
●Azure SQL DBA / Azure Data Warehouse knowledge
●Azure SQL Administrative tasks
●Established and enforced data warehousing standards to meet requirements and business needs.
●Evaluated current back-end processes. Create and improve the underlying data design and flow of information.
●Utilized Azure stack modules such as Data Factories, Data Lake, SQL DW and Synapse in support of ongoing data warehouse and reporting needs.
●Indexes, index management, integrity checks, configuration, patching
●SQL database backup, restore and recoveries
●Critical incident support and interactions with Microsoft.
●Leveraged Scrum agile methods allowing the deliverable software to continuous changes.
●Participated in all aspects of the Software Development Life Cycle(SDLC) from requirement gathering to engineering code review and testing.
SENIOR DBA: Managed Science Associates, Pittsburgh, PA (2020 - 2021)
Responsible for ongoing development and management of the servers and network, system security, overseeing department budget and planning, and maintaining accurate documentation including resource time tracking and network design documents. Provide daily support of individual computers and employees. Led special projects while ensuring they met strategic business requirements and were completed on time and within budget constraints. Responsible for management of several offshore IT team members.
Promotes career development and growth. Provide training to team members on IT Standards and corporate directives.
.
●Created and regularly use the Confidential Cloud/Microservices Assessment asset for identifying current level of best practices adoption, gaps, and roadmap for adoption of cloud/microservices practices
●Built reliable, scalable distributed systems for data analytics and reporting.
●Coached, guided, and mentored team members on Azure development best practices.
●Implemented and maintained security and authorization framework modules.
●Integrate and maintain Row-Level Security (RLS) methodology.
●Conducted root cause analysis and resolved performance and production problems and data issues.
●Hands (including others) in analysis, design, process and development of: Oracle, Mongodb, Spring, Spring Boot, Java, Jenkins, Maven, Kubernetes, Docker, Kafka, Prometheus, Sleuth, Zipkin, EFK, SAST, DAST, Angular, CSS, HTML, JUnit, Mockito, JMeter, Acceptance Testing, DevSecOps, DevOps, CI/CD, Sonar, Agile, ISTIO, Hystrix, Circuit Breaker, Gherkins, Cucumber, Selenium, Rest Assured, Camunda, Drools, Microservices design, Cloud architectures
●Monitor’s Oracle Database incident management processes minimizing the business impact and system downtimes.
●Monitoring and review of Change Management Compliance as it exists within Oracle.
●Leadment and Administration of Oracle RAC (real application cluster) system from design architecture to Replication implementation.
●High Availability: Implemented Data Guard (logical & physical) for maximum protection, performance and availability.
●Lead team of DBA’s (infrastructure) on site and off site spread across the globe. DBA categorized Administration, Application, Operation, Production, Change Management, NOC, On call support and performance optimization.
●Implemented the ITIL standard model of RDBMS for the DBA teams: Service Delivery, Service of Excellence and People for Managing and Maintaining Database systems.
●Defined the Cost saving structured Shared Service Model for the operational DBA team servicing multiple projects. Defined Outsource model across continents for rapid DB service requests.
SENIOR DBA: Glatfelter Insurance, York, PA (2018-2020)
Was responsible for budgeting and capacity planning, as well as systems performance and uptime management.
Drove continues improvement through optimizations of systems and processes for existing and new applications, tools and data technologies. Responsible for the management of multiple applications, data service areas and projects simultaneously to ensure on time response, quality delivery and resolutions. Acted as the department point of contact with cross functional teams, including product development, engineering, quality assurance and technical support working with global teams.
●SQL Server Hardware sizing and bottleneck tuning
●SQL Containers
●Lead the updating of the Oracle and SQLserver based technologies
●Coordinate with the architecture teams to design new software technologies for clients
●Solar Winds and Idera, Redgate and SentryMonitoring and Alerting systems for Oracle and MS SQL databases and systems
●Plan, Design, and Schedule Database Maintenance & Administrative Tasks
●Configuring Replication / Data Synchronization
●Toad Developer for Oracle and SQL
●SQL Server Database Monitoring with DDL Triggers SQL Server Profiler Event Notifications
●Data Quality and Master Data Service Design and Implementation
●Install, Lead & troubleshoot multi node multi site SQL Server clusters
●SQL Server Virtualization & Consolidation
●SQL Server Hardening & Best Practice Implementation
●Capacity Planning, Load Balancing & Scaling out SQL Server
DBA Lead: Fragomen, Pittsburgh, PA (2017- 2018)
Lead 8 direct reports supporting three divisions with annual revenues of $28M. Accountable for the strategic direction, implementation, support, and development of all business applications, including Data Warehousing, Enterprise Resource Planning (ERP), Facilitiesmanagement, Financials, Forecasting, Labor Management Systems (LMS), Manufacturing Execution Systems (MES), Procurement, Warehouse Management Systems (WMS), and Web Development as related to the print industry. Responsible for all IT needs of the organization in terms of strategy, solution architecture, products development for B2B/B2C, project delivery, Data Center Operations, security, infrastructure, and compliance. Secured expense reduction by leveraging economy of scale, new technology implementation, process re engineering, automation, and consolidation of services. Delivered risk management strategy through systematic and iterative process improvement. Expert in analyzing risk versus cost in meeting strategic needs of the organization to drive revenue.
●Decreased software defect rates by over 75% by implementing software quality tools and methods integrated throughout the development and SQA process.
●Improved product development pipeline output via introduction of Agile methodology and addition of a third party team for off hours development (offshore).
●Leadment of over 2 Petabytes of online data that is accessed at very high rate ($1M hits/day) with parallel ETL data processing within the Oracle Cloud
●Gathered user requirements, designed the framework using UML that included identifying the use cases and its surroundings, drawing use case diagrams, identifying classes, drawing class diagrams and sequence diagrams.
SENIOR Database Administrator: Heritage Valley Health System, Hopewell, PA (2017)(Contract)
●Database Professional, Performance Tuning, and Disaster Recovery
●Lead MS SQL/ Exchange Engineer responsible for designing, deploying, maintaining, troubleshooting, documenting and supporting Microsoft Exchange 2013/2016 Server and SQL 2012, 2016 and 2018 on premise environment.
●Acted as liaison for Development, Business Analysts, gathering requirements, implementing changes and resolve problems
●Complete daily monitoring, reporting and performance gathering on mission critical applications to SENIOR level business executives and management
●Created SSRS reports and shared databases to create accounting reports like purchase order and invoice.
Database Administrator: Vesuvius, Pittsburgh, PA (2010–2017)
●Lead a team of 10 IT professionals responsible for all corporate and local office systems, including applications, data center, servers and storage, PCs, and telecom. Reported to the VP of Technology.
●Completed a current state assessment; authored the firm’s IT strategy and project roadmap.
●Implemented changes resulting in over $200K in operating expense savings in the first year I performed in this role.
●Planned and Lead physical to virtual server migration; retired over thirty servers and saved over $200K in operating expenses.
●Led the evaluation and selection of new ERP systems and the back end DBs for the firm.
●Reorganized the Software Development / DB team to improve service levels. Transformed the Applications team to properly align skills with ongoing duties.
●Effectively prepared and presented large scale projects to the board of directors.
●Created computer security policy and disaster recovery procedures.
●Successfully deployed Cisco VoIP system throughout entire organization in saving over two hundred seventy thousand dollars in communication maintenance costs annually
●Extensive experience configuring/troubleshooting DTS Packages, Migration of DTS packages from SQL 2000 to 2005, 2005 to 2008R2 and 2008R2 to 20014. Create and Deployed SSIS (SQL Server Integration Services) Projects, Schemas and Configure Report Server to generate reports through SSRS.
●Extensive experience in installing, configuration and administration of MS clustering
●Extensive experience in SQL log shipping, mirroring and replication
●Implement and maintain database security, replication, SQL Clustering, Stand by server, DTS, SSIS, Log shipping, Database Mirroring, SQL Mail, Database Mail
●Performance tuning using Performance Monitor, SQL Profiler, SQL Query Analyzer and Index tuning wizards
●Responsible for all documentation of SQL server and database policies and procedures
●Responsible for the management of JDE, SAP, Cognos and PeopleSoft CRM/ERP databases
●Designed and Developed SQL environments for in house, SAP, JDE ERP/CRM databases
●Gather business requirements analysis, architecture design, physical and logical Data modeling, application development, testing, training, production support and Project review with external and internal clients.
●Supported 24X7 response teams for in house fully Lead services and network operations
●Networking was revamped based on Cisco Nexus 7K/5K/2k hardware introduction
●Implemented new SAN storage farm using Hitachi, 3PAR, and Netapps hardware, VM (RH) and MS based farm, load balancing using F5 hardware, HP as well as Sun environment, and virtualization using VMWARE and some Hyper V.management of ACLs for clients and migration across environments
●System study for ASP.NET projects to be developed offshore and initial man hours calculation for each subproject of the entire developmental process
●System flow and correlation design of individual projects along with documentation and initial idea transfer to the developing group
●Strategy planning for the client as to what project will initially be developed and what development process will run tangentially and what projects will follow in tandem to ensure successful project deadline
●Unit testing, plan and coding style of all methods in each class and preplanning of regression tests and forecasted deadline for the test process.
●Assessment and Proof of concept of all providers in the Data access layer and final determination of the implemented technology
●Scheduling of technology transfer to offshore team, selection of individuals to build each team and hands on C# coding style and principles to each member.
●Design of development goal for client review, forecasted dates and adjustment of project task load depending on client’s feedback.
SENIOR Infrastructure Architect: EFI, Pittsburgh, PA (2005–2010)
●Organized all IT functions around partnerships to better support business unit goals.
●Managed an IT infrastructure including Network LAN, WAN, MPLS Data Network, Data Centers, Disaster Recovery facilities, ERP applications, telecommunications, various third party applications including CRM, Internal reporting, database management and IT help desk.
●Developed IT standards and policies designed to streamline desktop and software support.
●Instituted Steering committee to align IT initiatives and improve organizational operations
●Installation, configuration, performance tuning, client/server connectivity, query optimization, back up/recovery, running Database Consistency Checks using DBCC, Data Modeling using ERWIN and Stored Procedures, Database Triggers and DTS package creation.
●Experience SQL Server Backup and Recovery features
●Implemented SQL Server security.
●Configured and automated SQL MAIL notifications.
●Designed and documented SQL Server Strategies and plans.
●Successfully migrated 200 SQL 2000 databases to SQL 2005
●Experience in handling the situations in change control process
●Used the SQL server integration services (SSIS) as a part top transfer login from SQL server 2005 to 2008 and to move data from one server to another server.
●Creating databases and logins with permissions in SQL Server 2008 as per the developer's request.
●Installed, configured and deployed SSIS, SSRS and SSAS.
●Involved in requirements gathering, documenting the requirements, developing, testing and implanting the system. Designed and created a Multidimensional model using MS SQL Analysis Server.
●Used different schemas like Star Schema to support large user queries and SnowFlake schema to support bulk inserting of data into data warehouses.
ACADEMIC CREDENTIALS
University of Phoenix, Phoenix, AZ
M.S.C.I.S. Master of Science in Computer Information Systems 11/2005
Geneva College, Beaver, PA
B.S. Business Administration 12/1999
Contact this candidate