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