We provide IT Staff Augmentation Services!

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

Hire Now