Database Developer/ Data Integration Support

• May 2008 - Present

DBA/DATA ANALYST

• Dec 2011 - Jul 2012

My responsibilities... • Wrote high level queries for reports analysis per Clients request. • Executed performance-improvement related activities mainly CPU/Memory/IO, and specific query performance tuning and worked closely with SharePoint developers and other stakeholders on Microsoft SQL server database. • Created stored procedures, triggers, functions per request by customer. • Executed Linux scripts manually (as needed) for weekly database refresh. • Created customized scripts for customer’s biometric reports. • Used Oracle SQL loader to load data tables and build out XML files. • Created tables, users, tablespaces, indexes, abstract data types, views, and also built high level queries with PL/SQL. • Tuned databases, performs troubleshooting and problem solving. • Ensured daily system backup scripts are functioning. • Created stored procedures, triggers, functions etc. • Created high level reports in excel, using pivotal tables. • Conducted UNIX/Linux System failure analysis and recovery; ensured consistency and integrity of file systems. • Demonstrated analytical skills in all aspects of data management and data-tier application development. • Managed client data via TOAD: export, import, creating tables, reports, materialized views, etc. Show less

Database Administrator

• May 2006 - May 2008