SUMMARY:

• Dedicated Database Architect with proven track record of Database Administration, Data Analytic and Data Management experience. Deep understanding of every aspect of system's performance across database operations, host server and OS, virtualization resources and storage I/O.
• Started with the company of only 50 employees in a single location and supported its growth to America’s #1 Term Life Sales Agency, Auto, Home and Medicare Supplement business with six offices, 1000s database users and three datacenters.
• Owned, designed, implemented and supported multiple Database environments:
• Production, Parallel, Staging, QA, Reporting and Development and keeping them in sync.
• Off the charts analytical thinker with skills allowing to assess complicated issues, identify root cause elements and quickly find the most efficient solution.
• Designed and developed the policies and procedures for monitoring and alerting of technology infrastructure systems and networks to reduce downtime. Developed numerous dashboards: Business decision, Informational, Alerting.
• Expert in multi - sites replication. Designed and support three data centers. Great working experience on building data center from the ground up.
• Strong knowledge of the underlying infrastructure such as Networking, Storage, and Hardware Optimization.
• Deep expertise on Windows OS fundamentals and management, hands on Scripting, Database and Systems Skills.
• Ability to prioritize and work on multiple projects concurrently.
• In-depth knowledge of relational database design and ability to develop stored procedures, views, indexes, user defined functions, and triggers.
• Working knowledge in data encryption, protection as well as security compliance and auditing. Familiar with SOX and PCI DSS audit processes and HIPAA requirements.
• Extensive experience in data parsing and tools.
• Ability to work within an Agile team framework.
• Expertise in backup. Created multilevel backup solution for database servers.
• In-depth knowledge of PDF Documents, TIFF images, scans.
• Familiar with the 24/7/365 support mentality.
• Active member of SF and Silicon Valley Microsoft Data User Groups.

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Database Architect

• Manage Databases, Servers, Storage, VMs, Disaster Recovery, Replication, Data exchange, schema design, application performance tuning, production support and database securities, infrastructure, architecture, servers capacity planning. Helped Confidential become America's number one term life insurance agency. Performed multiple builds, installs, version upgrades and migrations of production systems with minimum downtime.
• Own, develop and support SQL Server databases, specializing in SQL Server 2012, 2014 and 2017. Oversee data architecture design for Confidential Information Technology. Maintain large data warehouses and adjust them to scale for performance.
• Created and maintain Repository of database's scripts and schema changes. Moved servers and databases to Azure. Created Sarbanes-Oxley Act (SOX) and PCI DSS compliant infrastructure servers and database structure. Worked on HIPAA database compliance using different encryption methods and data obfuscation.
• Created Monitoring and Analytics dashboards utilizing Grafana web front end, InfluxDB time series database and Telegraph measurement collecting engine. Created multiple Business decision and Informational dashboards.
• Provide expertise in T-SQL for MS SQL Server.
• Streamlined and automated Deployment and Release processes by custom shell scripts.
• Setup Replication, Log Shipping, Mirroring and Storage DR.
• Manage real time XML, JSON data exchange with multiple vendors. Develop ETL, DTS, SSIS packages.
• Participated in Machine Learning projects.

Skills: MS SQL Server, Windows Server 2012R2-2016, Azure, ETL, PowerBI, Azure Cosmos DB, Shell scripting, PostgreSQL, Grafana, InfluxDB, SNMP, Jira, Confluence, Bitbucket, Git, Solarwinds, SentryOne, Idera, Powershell

Confidential, San Francisco, CA

Senior Database Administrator

• Database Production Support, SQL Server Builds and Upgrades, Windows Clustering. Database troubleshooting and performance tuning. Monitoring, Alerting and Auditing.
• Hardware, Software, Capacity and Power analysis for optimal database infrastructure. Hardware and Software procurement with various vendors.
• Database Firewall. Built the whole database structure in a new data center from the ground up and establish high availability and disaster recovery model.
• Single-handed created company-wide web-based Document repository which collected documents, scans, emails, attachments, images, media files into searchable database.
• Created multiple command line data parsing scripts for production data feed, server performance monitoring, log recording.

Skills: MS SQL, Windows Server R2, Hyper-V, NeverFail, Dashboards, MRTG, Nagios, Pure Storage, Imperva, FTP, Telnet, POP, IMAP, SMTP, SNMP, SED, AWK

Confidential, San Francisco, CA

Database Administrator

• Managed, installed, enhanced, tuned and troubleshot MS SQL Server RDBMS.
• Administered, maintained, developed and recommend policies and procedures for ensuring the security and integrity of the company's databases. Configure database servers.
• Analyzed and resolved performance bottlenecks. Defined monitoring strategies. Provided database management support. Established and managed security integrity controls. Performed maintenance and performance tuning.
• Developed and supported database disaster recovery plans and backups. Maintained High-availability 24x7 systems with multiple disaster recovery offsite locations. Ensured multiple database environments such as Development, Staging, QA, Reporting, Parallel and Production are in sync.
• Great experience with database/operating system performance monitoring and enhancement. Provide expertise in T-SQL for SQL Server. Expert in developing Monitoring scripts and Alert systems.

Skills: SQL Server, MySQL, RedGate, Idera, Qualys Security scans

Confidential, San Francisco, CA

System Consultant

• Created databases for litigation, investigations and regulatory proceedings. Manipulated large amount of data among different databases and applications. Provided data conversion services, data analytics, data validation and statistical sampling. Created databases for huge volume of documents and images.
• Provided system maintenance, database updates and support. Implemented various litigation support packages and image retrieval systems. Installed computer equipment at multiple client sites, and provided client training. Implemented document management systems for legal companies.

Skills: SQL, C, MS SQL Server