Database Support Analyst Resume

SUMMARY:

IT professional with more than 10 years’ experience in vast areas of Information Technology ranging from hardware and Application Support. Database Admin and SQL Developer.

TECHNICAL SKILLS:

SAP Crystal Reports
Tableau
Oracle Business Intelligence 11g
Creating Repository from metadata in the Physical Layer
Modelling and organizing the data in the Business Layer
Creating Reports and KPI in the presentation Layer
Windows server, Azure, AWS, MySQL, Access, VB, Java, HTML, Remedy, Sherwel

PROFESSIONAL EXPERIENCE:

Confidential

Database Support Analyst

Responsibilities:

Involved in Database migration from the Legacy System to the new System
Writing T - SQL scripts to query and update database tables.
Creating and maintaining triggers and stored procedures,
Creating Views for quick data access.
Testing and maintaining data integrity.
Perform Ad-Hoc queries whenever required.
Maintaining and updating Master Database.
Liaising with front end product development teams.
Supporting SQL Server Database OLTP and DSS systems
Involved in Monitoring and troubleshooting replication issues
Monitoring SQL server performance using profiler to find performance and deadlocks.
Providing necessary support to front end user as and the Engineering team

Confidential

Business Intelligence Analyst / Database Developer

Responsibilities:

Used SSIS to migrate data
Created database objects
Designed tables, views, reports
Generated reports using SQL Server 2008 R2 Reporting Services (SSRS)
Deployed Custom Reports to Reporting server.
Created clear visualizations for data presentation
Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing through Maintenance Planner
Performed Database backup and restores.
Performed SQL Server log shipping
Performed SQL Server Transactional Replication.
Setup automated maintenance jobs in SQL Server agent and task scheduler: such as, backup database, index rebuilding, creating filtered indexes, index reorganizing, cleaning up, and updating statistics
Maintaining the database consistency with DBCC at regular intervals
Creating SQL Server Logins, Authentication and assigning Roles as part of Security policy
Created Maintenance Plans that helped in effective disk utilization and index maintenance.
Created, Scheduled and monitored SQL Server Jobs, making sure jobs run successfully

Confidential

Application Analyst

Responsibilities:

Cerner System configuration and Builds
Setting up patient lists in the Patient Database
Supporting physicians, nurses and other clinical staff.
Used proprietary modules to produce Ad-Hoc reports
CPOE and Registration support.
Regularly monitored HL7 system, Cloverleaf, to make sure all systems were running
Monitored some Application Databases making sure they ran optimally.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship