Sql Database Server
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 MS SQL Server and Oracle Database. Experience with Azure SQL database.
Experience with supporting Epic, Cerner and AthenaOne EHR Application. Experience With Epic and Cerner ATE End user support (Inpatient and Outpatient Modules). Experience with MongoDB Database, MongoDB Compass, Studio 3T. Experience with data Encryption.
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.A Information Management and Systems / Business Administration. Southern Polytechnic State University May 2008.
Experience
Sr. Business Intelligent Data Analyst / SQL DBA December. 2022 – Present (Remote Contractor) Midwest Orthopedic at Rush. Chicago, IL.
Provide DBA 7x24 and on call Support for Azure SQL database.
Use Azure Monitor, SQL DB Advisor and Query performance insight to identify bottlenecks.
Troubleshoot and resolve application issues.
Generate reports from AthenaOne application.
Work on resolving patient work queues issues.
Perform ETL data load from data source Snowflake, Azure, excel and csv file to Power BI.
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.
Troubleshoot errors and improving existing BI systems.
Support and maintain Azure SQL database.
Generate monthly patient custom satisfaction survey 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 December. 2021 – Nov. 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.
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.
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 and resolve ticket.
Database Administrator. August. 2021 – December 2021 (Remote Contractor) Net Health. PA
Provide DBA 7x24 and on call Support for Azure SQL database.
Use Azure Monitor, SQL DB Advisor and Query performance insight to identify bottlenecks.
Perform Reminder Call\ TeleVox installs and support.
Perform SP Optimization and addressing perimeter sniffing.
Perform Clinic Doc nstall, Clinic Report install, Report Assembly processor install.
Recreate CPGs.
Configure and monitor Azure SQL database.
Use Azure Monitor, SQL DB Advisor and Query performance insight to identify bottlenecks.
Troubleshoot and resolve application issues
Troubleshoot and resolve performance issues in SQL server.
Configure and manage maintenance jobs.
Create, manage and support user access and DB security permission.
Create and maintain user role based access control.
Enforce database security policies.
Implement data Encryption and manage user access controls to protect data. SQL Database Administrator. September. 2020 – July 2021 (Remote Contractor) New York eCollaborative NYEC. New York, NY.
Provide 7x24 and on call database Support for SQL database.
Manage SQL Server for various environment (Dev/Prod)
Configure and manage Always On Solution for Production Environment.
Support 18 Clinical applications .
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.
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 – September. 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)
Configure and manage Always On HA DR Solution for Production Environment.
Configure and monitor SQL Server database to backup to Cohesity platform.
Configure Linked Servers in production environment.
Document and maintain standards for database configuration, maintenance, and security.
Install database patches.
Perform Migration upgrades to a higher version of SQL server.
Troubleshoot and resolve application issues
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. Oct. 2019 – Jan. 2020 (Remote Contractor) Incomm. Atlanta, GA.
Provide 7x24 and on call database Support for SQL database.
Manage SQL Server DB for various environment (Dev/QA/Load/UAT/Prod)
Configure and monitor Azure SQL database.
Use Azure Monitor, SQL DB Advisor and Query performance insight to identify bottlenecks.
Troubleshoot and resolve application issues
Troubleshoot and resolve performance issues in SQL server.
Configure and manage maintenance jobs.
Configure DB backups for disaster recovery and point in time recovery.
Monitor and resolve deadlocks, blockings and DB alert using SentryOne.
Monitor and resolve space alert issue using Nagio.
Support deployment and change requests to production databases.
Support load team in monitoring the database servers during load test.
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.
Create and maintain user role based access control.
Implement and maintain backup and recovery strategies.
Monitor and resolve ticket.
SQL Database Administrator. March. 2019 – Oct. 2019 ( 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.
Troubleshoot and resolve application issues
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.
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. Sept. 2013 – August. 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 – August. 2013
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.
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. Support Engineer, Jan 2004- December. 2007
NeoCom Soultion,Inc Woodstock, GA.
Manage selection of subcontractor and material purchasing.
Monitor progress of construction activities.
Track and monitor project schedules.
Enforce and monitor worker safety and productivity.
Manage client expectations.
Perform sweeps and PIMS closeout using Anritsu master software tool.
Label antennas per DWS and coordinate delivery of material, coax and antenna to job-site.
Perform site survey closeout and photo closeout using fast sone image viewer.
Document coding standards, lessons learned, best practices, and QI documentation.
Monitor space usage and adjust database as needed.
Create and maintain database backup.
Perform data update on client tables.
Contact this candidate