Data Analyst/ DBA Resume

SUMMARY

Good understanding of SQL server and databases
Good in database administration and development activities such as Installation & Configuration of SQL Servers 2008R2, 2012 and 2014.
Good in managing user permissions, roles, and security of the MS SQL databases.
Experience using SQL - Server and TSQL in creating, and tuning Views, and Stored Procedures
Understand and hand on experience with Windows Servers 2008, and 2012 R2
Experience with installations, configuration and troubleshooting computing and network devices like hubs, routers and switches
I have experience with system upgrades and maintenance
Reliable and trustworthy
Experienced using MS Excel, Tableau, PowerPoint and MS Word for reporting and presentation

PROFESSIONAL EXPERIENCE

Confidential

Data Analyst/ DBA

Responsibilities:

Installed and configured SQL servers.
Installed database software service packs and cumulative updates as necessary.
Assisting with overall database design, tune queries, assigning proper indexes.
Understand T-SQL writing of stored procedures, triggers, functions, Store Indexes, Replication and Partitions
Creation of triggers and stored procedures in databases.
Granted users privilege and access to the database and revoked user’s privilege when necessary.
Providing expertise on data storage structures, data mining, and data cleansing.
Adhering to guidelines about keeping data confidential.
Setup maintenance job for database backup.
Performed database Ad-hoc backups and restores.
Assisted with database recovery process
Utilizes data warehousing program, MS SQL, Tableau and other dashboard/visualizing toolset for data intelligence and analysis.
Verifies to ensure that products listed online are updated to reflect the available stock
Experienced using MS Excel, Tableau, PowerPoint for reporting and presentation

Data Analyst/ Volunteer Junior DBA

Confidential

Responsibilities:

Installed and configured SQL servers.
Installed database software service packs and cumulative updates as necessary.
Assisting with overall database design, tune queries, assigning proper indexes.
Creation of triggers and stored procedures in a database.
Performed database Ad-hoc backups and restores.
Assisted with database recovery process
Utilizes data warehousing program, MS SQL, Tableau and other dashboard/visualizing toolset for data intelligence and analysis.
Knowledge of creating and scheduling T-SQL jobs to run daily.
Help with the Facilitation and driving of project team meetings
Track project performance