We provide IT Staff Augmentation Services!

Database Admin / Project Manager Resume

2.00/5 (Submit Your Rating)

Irvine, CA

SUMMARY

  • Designed and Maintained data infrastructure systems, policies, and processes that instilled high levels of quality assurance and system integrity for government clients and public companies.
  • SQL Database Administrator certification (MCITP DBA 2008 ) and experience with SQL 2014/2016, MS SQL Cluster Server
  • Award Winning: Vinci's Innovation Award, TechCrunch Disrupt SF Audience Choice.

TECHNICAL SKILLS

  • Data Infr Design, Install, Manage, Config: SAN, Cisco, VMware, WinServer, WSFC, SQL, IIS
  • Storage Area Network Design and Maintenance, Netapp/Drobo/Nimble.
  • OLTP high transaction volume payment systems w/transactional replication to SSRS.
  • SSIS ETL, SQL Job Development, Win Task Scheduler Job Development
  • Project management ~ (PMP Pending) 5+ Years IT Solutions Deployments
  • Backend data integration / support for MS Dynamics CRM.
  • Languages: t - sql, c#, html, css, javascript

PROFESSIONAL EXPERIENCE

Confidential - Irvine, CA

Database Admin / Project Manager Responsibilities:
  • SQL DBA for 300+ avg. transactions/second OLTP database over 1TB in size spanning multiple file groups on NetApp, HP, and Nimble iSCSI SAN and MS SQL failover clustering w/PCI compliance.
  • Proprietary tolling system with 600,000 annual credit card transactions serving 40,000 average daily commuters with approx. $40M annual gross revenue.
  • Designed and deployed the on-premise development, QA, data, network, virtual, and Production environment for a new proprietary tolling revenue and account management software application installed in 2011. Recipient of Vinci Innovation Award.
  • Designed and re-deployed the hardware, data, and application stack three additional times over 6 years. Designed and deployed Production SQL migration via Log Shipping.
  • Served as co-architect and engineer for NetApp iSCSI SAN, VMware virtualization, SIEM solutions, IDS/IPS, RSA VPN, Cisco ASA 5500 series firewalls, routers and layer 3 switches.
  • Designed and maintained Application Change Management with TortoiseSVN and Redgate tools, created documentation of full-stack Hardware and Network Design, and supplied reportable audit evidence of all updates, inserts, and deletes in OLTP db including reason, date/time of action, and sign-off.
  • On-call 24/7 monitoring, maintenance, capacity planning, backup and recovery, created stored procedures, SSIS packages, ad-hoc queries, converted Perl to T-SQL scripts and stored procedures / SQL jobs. Managed/Maintained Perl Script-based TS jobs. Deployed and Maintained Replication-Based SSRS instance. Tuned SQL code via refactoring, query editing and indexing, yielding in 40% improved performance. SAN I/O load balancing.
  • Full-Scale Enterprise Exchange Server Deployment at two separate locations/ADs with Office365 Cloud Integration.
  • Performance tuning, monitoring, SQL profiler, Extended Events, Dynamic Management Views (DMVs), SQL IO, DiskSpd etc. with established baselines and metrics.

Confidential - Irvine, CA

SQL DBA / CRM Solution Designer / Cluster Engineer

Responsibilities:

  • Designed and Deployed Private-Cloud Hyper-V Cluster to Rackspace with Fibre Channel NetAPP SAN shared storage, VM-Manager, and Microsoft System Center.
  • Deployed MS Dynamics CRM 2011 Server with WSFC-based SQL Instance backend.
  • Deployed and Developed custom MS Dynamics Customer Solutions for Private-Cloud clients.

Confidential - Irvine, Ca

Director of Systems Integration / Infrastructure

Responsibilities:

  • Designed and Deployed MS Hyper-V based developer environment with direct attached Drobo SAN.
  • Deployed LAN and Developer solutions: SQL 2008 R2, MS Team Foundation Server, Active Directory Services, Sonicwall Security and VPN
  • Deployed MS Dynamics CRM 4.0 Server with Custom CRM Solution mapped to Cloud-Onboarded Vendors and Mobile Application Customers.
  • TechCrunch Disrupt SF Audience Choice Winner, 2010

We'd love your feedback!