SUMMARY:

• To seek a position as a SQL Server DBA/SQL Support Analyst to utilize my skills and expertise in the field of SQL Server database administration. Eager to learn new opportunities.

WORK EXPERIENCE:

Confidential

SQL Server Database Administrator

Responsibilities:

• Supported DB environment using SQL server version 2014
• Performed migration from centurylink physical servers to AWS EC2 instances which significantly cut down on operating costs.
• Initiated a shutdown plan for lower db environments which saved the company $180,000
• Utilized DPA Solarwinds monitoring tool to diagnose slow running queries, disk space, SQL data/log file sizes, setting up alerting when filegroups went below certain thresholds.
• Active role in SQL development (functions, stored procedures, SSIS package(s), views, adhoc requests)
• Automated restore of lower environments post restore of Production AWS snapshot so latest data is there for development with as little downtime as possible.
• Java Development on Talend IDE
• Created SQL naming conventions document.

Confidential

SQL Support Analyst

Responsibilities:

• Worked with SQL Server version 2012
• Ensuring SQL Maintenance jobs are running successfully for backups, index rebuilds.
• Production support weekends and evening overseeing SSIS load processes, report send, and server/file system state.
• Developed and created SSRS reports using IDE Visual Studio 2010 for Internal/External customers.
• Well versed in Ad Hoc scripting, views, stored procedures,SSRS reports, SSIS packages. Had a chance to do a lot of development work.
• Helped tune and migrate main morning flat files load process and helped optimize to Consolidated morning process with better validations/functionality.
• Built and Supported SSIS processes which load/processed credit card data for Discover, Amex,Voyager, and Wex.
• Exposed to SQL tools RedGate software suite which included (Source Control,Redgate SQL Compare, SQL Prompt)

Confidential

Jr. SQL DBA

Responsibilities:

• Worked with SQL Server versions SQL 2000 - SQL 2012
• Management of SQL server users and logins
• Memory or disk space problems Configuring backup/retention policy in sql server
• Well versed in Idera SQL Diagnostic Manager
• Generating SSRS reports
• Helped startup and support new Sharepoint site.
• Support vendor, and hosted SQL applications
• Worked with ServiceDesk application, to resolve database related requests and changes per SLA
• Installing SQL instances and features such as SSRS, SSAS, DB engine, and SSIS enterprise and standard editions
• Deploying and configuring SSIS packages for ETL
• Worked with Datawarehouse folks to save databases that are to be used for analysis to the Azure cloud

Confidential

Database Administrator

Responsibilities:

• The users cannot access server, managing sql server logins and users. Ensuring appropriate rights
• Creating login accounts and groups for odbc connections for excel and MS access to Sql server
• Granting user permissions for objects within database and working in coordination with AD team to allow access to file shares for new consultants/employees
• Memory or disk space problems Configuring backup/retention policy in sql server
• Working with Oracle’s EPM system sql database and monitoring database backups, log shipping, and disk space
• Configuring other HA/DR tools such as Mirroring, replication
• Backup schedule and retention policy along with data restore for applications team
• Disaster recovery solutions such as log shipping databases, replication, mirroring.
• Familiarity with windows clustering and administering SQL cluster for high availability and disaster recovery
• Running traces in sql server profiler. To track long running queries and database changes
• Working with Database Tuning Advisor to create indexes on highly transactional tables.
• Applying Server & Sql patches, hotfixes, and cumulative updates
• Index Reorganization & Rebuild via Ola Hallengren scripts on DEV, QA, PROD, and DR environments
• Working database related ticket requests
• Installing SQL instances and features such as SSRS, DB engine, and SSIS enterprise and standard editions
• Deploying and configuring SSIS packages for ETL

Confidential

Database administrator

Responsibilities:

• Maintained 50 SQL Server servers including 2005, 2008, 2012 versions supporting about 500 databases. The largest server was about 1600 gigs and largest database is about 50 Gigs. Working with the ticket queue systems helping the users resolving their everyday issues.Issues like:
• The users cannot access the server.
• Creating login accounts.
• Granting user permissions.
• Determining cause of slow running queries.
• Memory or disk space problems.
• Backups and restore.
• Copying data to other databases, replication, mirroring.
• Creating new databases, tables, indexes, stored procedures, triggers, server roles, linked server jobs, maintenance plans, running traces in sql server profiler.
• Starting and rebooting the server, starting and rebooting the sql server services.
• Granting temporary excess privileges.
• Monitoring and troubleshooting after hours and over the weekends.
• Printing the reports using SSRS.
• Using ETL tools like SSIS for different jobs and much more.

Confidential

Data Analyst

Responsibilities:

• Maintained the databases, prepared the reports and also maintained their books using the Microsoft Access and Microsoft Excel. Made sure the data was available on time and was updated on a regular basis.
• Input all faxed and or emailed therapy notes into electronic system
• Insure therapists are submitting notes and adhering to plan of care, frequency
• Billing out for Advocate Hospitals home health division
• Mediate between home health therapists and facility nurses