Sql Server Data Analyst
Resume:
STEPHEN MOSERI
******.**********@*****.***
OBJECTIVE
A proven dedicated IT professional with strong analytical, organizational, support and databaseadministration skills, seeking a challenging position with an Innovative company.
SKILLS
Experience with supporting Epic, Cerner and AthenaOne EHR Application.
Experience With Epic and Cerner ATE End user support (Inpatient and Outpatient Modules).
Experience with MS SQL Server and Oracle Database.
Experience with Azure and AWS cloud.
Experience with Postgres Database, MongoDB Database, MongoDB Compass, Studio 3T.
Experience with data Encryption.
Experience with SSIS, SSAS, and SSRS.
Strong working knowledge of Microsoft Office and Teams.
Experience working with SentryOne, Nagio, Red-Gate, Splunk, Service Now and Active Roles 7.3 console, Cohesity, Opsview, and Idera.
Languages: VB and XML, TSQL, HTML, .NET, PowerShell, Python, C#/C++.
Microsoft Certified MCSA 2012
Office Package/Tools: MS Access, Telnet, FTP, Excel, MS Office, MS frontage, Power Point, Visio, Dream, Weaver.
Operating systems: MS-Windows XP/2000/NT, Win Server 2000-2019
Networking: Cisco VPN, Network Connectivity, Network Security, IDS, Disaster Recovery, Forensic.
Automated Tools: Test Director 9.0, Win Runner 7.01; 8.02, and Quick Test Pro, (QTP),
Servers: Clear Case, SQL Server, Win CVs, Apache, IIS, Engine X (Ngnix), GWS.
Education
B.S Information Management and Systems / Business Administration.
Southern Polytechnic State University May 2008.
Experience
Sr. Business Intelligent Data Analyst / DBA Jan 2023 – Present (Remote Contractor)
Midwest Orthopedic at Rush. Chicago, IL.
Provide DBA 7x24 and on call Support for Azure SQL database.
Install and configure SQL Server instances.
Set up and maintain database servers and processes, including monitoring system health and performance
Monitor and optimize database performance using tools like SQL Profiler, Execution Plans, and Dynamic Management Views (DMVs).
Perform regular database maintenance tasks such as backups, restores, and index rebuilding.
Maintain and upgrade IIS environments.
Configure security settings such as SSL and LDAP.
Generate reports from AthenaOne application.
Install, configure, and troubleshoot web application.
Perform Load and perfomance testing.
Regularly audit database security and ensure compliance with organizational policies and regulations.
Create and Maintain IAM role policy on AWS console.
Implement and maintain database security measures, including user access controls and permissions.
Migrate Oracle RDS to AWS.
Create design specifications for systems, and design data flow solutions to meet business needs.
Ensure data is processed accurately and efficiently.
Create custom SQL scripts, stored procedures, and triggers.
Perform design validation, reconciliation, and error handling.
Design data models, ETL pipelines, and near time data solutions.
Optimize SSIS Package execution and SQL execution.
Establish methods and procedures for tracking data quality.
Work on resolving patient work queues issues.
Develop and test disaster recovery plans to ensure data can be recovered in case of failure.
Create dashboard with Power BI to help business use their data strategically.
Design data models to make complex data sets easier to understand.
Maintain data integrity and ensure data quality and reliability.
Manage security, access, and licensing of the Power BI tool.
Train end user-users on how to use power BI based reports and dashboards.
Configure and manage Power BI.
Troubleshoot errors and improving existing Power BI systems.
Support and maintain Azure SQL database.
Troubleshoot and resolve database-related issues, including connectivity, performance, and data corruption.
Creates reports using MDX and SQL.
Plan and execute database upgrades and patches.
Design cubes using Snowflake and Star Schemas.
Defines report layouts for formatting the report design.
Identify data sources and data source views.
Generate monthly patient report from PatientIQ.
mplement and maintain backup and recovery strategies.
Perform Query Optimization to improve performance.
Monitor, troubleshoot and resolve performance bottlenecks.
Create, manage and support user access and DB security permission.
Enforce database security policies.
Implement data Encryption and manage user access controls to protect data.
Lead Clinical Application Analyst / SQL DBA Jan. 2022 – Dec. 2022 (Remote Contractor)
SUNY Downstate Medical Center. New York.
Provide 7x24 and on call database Support for SQL database.
Support and manage 23 Clinical application.
Install and configure SQL Server instances.
Perform application procurement, implementation, end user training and Go-live activation.
Respond and resolve business owner application issue request.
Resolve application Ticket request on Footprint.
Manage SQL Server for various environment (Dev/Prod)
Configure and manage Always On Solution for Production Environment.
Work with application team to understand DB configuration requirement.
Manage and schedule application database implementation.
Troubleshoot and resolve database related application issues.
Support application and development team as database SME.
Implement and maintain backup and recovery strategies.
Perform Query Optimization to improve performance.
Plan and execute database upgrades and patches.
Monitor, troubleshoot and resolve performance bottlenecks.
Create, manage and support user access and DB security permission.
Enforce database security policies.
Provide technical support and guidance to application developers and end-users.
Implement data Encryption and manage user access controls to protect data.
Monitor and resolve ticket.
SQL Database Administrator. Jan. 2021 – Dec. 2021 (Remote Contractor)
New York eCollaborative NYEC. New York, NY.
Provide 7x24 and on call database Support for SQL database.
Provide technical support and guidance to application developers and end-users.
Manage SQL Server for various environment (Dev/Prod)
Configure and manage Always On Solution for Production Environment.
Plan and execute database upgrades and patches.
Support 18 Clinical applications .
Troubleshoot and resolve database-related issues, including connectivity, performance, and data corruption.
Perform regular database maintenance tasks such as backups, restores, and index rebuilding.
Create design specifications for systems, and design data flow solutions to meet business needs.
Ensure data is processed accurately and efficiently.
Create custom SQL scripts, stored procedures, and triggers.
Perform design validation, reconciliation, and error handling.
Design data models, ETL pipelines, and near time data solutions.
Optimize SSIS Package execution and SQL execution.
Establish methods and procedures for tracking data quality.
Work with application team to understand DB configuration requirement.
Manage and schedule application database implementation.
Troubleshoot and resolve database related application issues.
Document changes and updates to the database environment.
Support application and development team as database SME.
Implement and maintain backup and recovery strategies.
Perform Query Optimization to improve performance.
Monitor, troubleshoot and resolve performance bottlenecks.
Create, manage and support user access and DB security permission.
Enforce database security policies.
Implement data Encryption and manage user access controls to protect data.
monitor SQL server with Idera.
Database Administrator. Jan. 2020 – Dec. 2020 (Onsite Contractor)
Kubota Manufacturing of America Gainesville, GA.
Provide 7x24 and on call database Support for SQL database.
Manage SQL Server for various environment (Dev/Prod).
Provide technical support and guidance to application developers and end-users.
Develop and test disaster recovery plans to ensure data can be recovered in case of failure.
Install and configure SQL Server instances.
Configure and manage Always On HA DR Solution for Production Environment.
Configure and monitor SQL Server database to backup to Cohesity platform.
Perform regular database maintenance tasks such as backups, restores, and index rebuilding.
Configure Linked Servers in production environment.
Maintain and upgrade IIS environments.
Work closely with developers, system administrators, and other IT staff to ensure database systems meet organizational needs.
Configure security settings such as SSL and LDAP.
Document and maintain standards for database configuration, maintenance, and security.
Install database patches.
Regularly audit database security and ensure compliance with organizational policies and regulations.
Create design specifications for systems, and design data flow solutions to meet business needs.
Ensure data is processed accurately and efficiently.
Create custom SQL scripts, stored procedures, and triggers.
Perform design validation, reconciliation, and error handling.
Design data models, ETL pipelines, and near time data solutions.
Optimize SSIS Package execution and SQL execution.
Establish methods and procedures for tracking data quality.
Perform Migration upgrades to a higher version of SQL server.
Troubleshoot and resolve application issues.
Document changes and updates to the database environment.
Troubleshoot and resolve performance issues in SQL server.
Configure and manage maintenance jobs.
Perform Query Optimization to improve performance.
Monitor, troubleshoot and resolve performance bottlenecks.
Create, manage and support user access and DB security permission.
Implement and maintain backup and recovery strategies.
Analyze stored procedure for security and performance to minimize downtime and data loss.
Maintain relationships with all lines of business through customer focused service delivery.
Create and maintain tables, indexes, and load data.
SQL Database Administrator. March. 2019 – Jan. 2020 ( Remote Contractor)
Appalachian Regional Healthcare. Hazard, KY.
Provide 7x24 and on call database Support for SQL database.
Implement and maintain backup and recovery strategies.
Perform Query Optimization to improve performance.
Install and configure SQL Server instances.
Work closely with developers, system administrators, and other IT staff to ensure database systems meet organizational needs.
Implement and maintain database security measures, including user access controls and permissions.
Troubleshoot and resolve application issues
Perform regular database maintenance tasks such as backups, restores, and index rebuilding.
Configure and manage SQL Always ON HA DR solution.
Investigate and resolve technical database issues.
Enforce database security policies.
Implement data Encryption and manage user access controls to protect data
Monitor, troubleshoot and resolve performance bottlenecks.
Create, manage and support user access and DB security permission.
Create and maintain user access.
Implement and maintain backup and recovery strategies.
Sr. Database Administrator August. 2014 – Feb. 2019
General Motors. Roswell, GA.
Provide 7x24 and on call database Support for SQL and Oracle database.
Mentor Junior DB team members and Provde KT as needed.
Respond to DB related high priorty alert and escalations, and resolve within established SLAs.
Perform changes in production per change management procedure.
Configure and manage SQL Always ON HA DR solution.
Investigate and resolve technical database issues.
Troubleshoot and resolve database-related issues, including connectivity, performance, and data corruption.
Create design specifications for systems, and design data flow solutions to meet business needs.
Ensure data is processed accurately and efficiently.
Work closely with developers, system administrators, and other IT staff to ensure database systems meet organizational needs.
Create custom SQL scripts, stored procedures, and triggers.
Develop and test disaster recovery plans to ensure data can be recovered in case of failure.
Perform design validation, reconciliation, and error handling.
Design data models, ETL pipelines, and near time data solutions.
Optimize SSIS Package execution and SQL execution.
Establish methods and procedures for tracking data quality.
Install and support MS SQL DB Services SSRS, SSIS and SSAS.
Configure SQL HA solutions Clustering, mirrioring and Replication
Configure and support Oracle DATAGUARD.
Configure and manage 4 node Oracle 11g and 12c RAC databases with ASM Storage.
Configure and maintain Oracle RMAN Backups.
Ensure SOX compliance and audit requirements.
Perform database patch upgrades.
Configure and maintain OEM to meet GM Standard.
Analyze database performance reports and provide tuning Recommendations.
Implement and maintain backup and recovery strategies.
Perform Query Optimization to improve performance.
Monitor and resolve ticket.
Work closely with Developers to design DB architecture and optimize queries
Enforce database security policies.
Implement data Encryption and manage user access controls to protect data
Monitor, troubleshoot and resolve performance bottlenecks.
Create, manage and support user access and DB security permission.
Document and maintain standards for database configuration, maintenance, and security.
Proactively assessing DB storage needs and scaling DB as required.
Database Administrator. Jan 2013 – Aug. 2014.
Boeing. (TCS). Troy, Michigan.
Provide 7x24 and on call database Support for SQL and Oracle database.
Monitor and resolve ticket.
Work closely with Developers to design DB architecture and optimize queries
Enforce database security policies.
Implement data Encryption and manage user access controls to protect data
Monitor, troubleshoot and resolve performance bottlenecks.
Create, manage and support user access and DB security permission.
Document and maintain standards for database configuration, maintenance, and security.
Proactively assessing DB storage needs and scaling DB as required.
Monitor, schedule and resolve DB backup operations.
Perform Migration and upgrade activities.
Database Administrator. Jan 2008 – Dec. 2012
Dish Network. Spartanburg, SC.
Provide 7x24 and on call database Support for SQL and Oracle database.
Create and maintain user access.
Deploy and maintain database cluster environment.
Install and configure SQL Server instances.
Develop process to optimize DB security and protect data.
Monitor and manage database to ensure optimal performance.
Troubleshoot and resolve performance bottlenecks.
Perform Query Optimization to improve performance.
Create Maintenance plan for better performance.
Implement and maintain backup and recovery strategies.
Analyze stored procedure for security and performance to minimize downtime and data loss.
Maintain relationships with all lines of business through customer focused service delivery.
Create tables, indexes, analyze stored procedures and load data.
Create documentation and coding standards, lessons learned, best practices.
Contact this candidate