SUMMARY

• Senior - level data professional specialized in designing, deploying, and managing an organization’s data architecture on the Microsoft SQL Server data platform. Areas of expertise include providing scalability,
• High Availability (HA), Disaster Recovery (DR), migration and consolidation expertise on the Microsoft SQL Server platform (on-premises and Cloud).
• Possess strong organizational and time management skills. Work with both minimal supervision and in a collaborative team environment.
• Assist clients map the systems and interfaces used to manage data, set standards for data management, analyze current state and conceive desired future state, and conceive projects needed to close the gap between current state and future goals.
• Experience building and maintaining complex mission-critical production database systems.

TECHNICAL SKILLS

• Windows Server 2012 R2/2016/2019
• SQL Server 2005/2008 R2/2012/2014/2016/2017/2019
• AlwaysOn Availability Groups
• SQL Server BI Stack (SSAS/SSIS/SSRS)
• SSDT OLTP
• SolarWinds DPA for SQL Server
• MySQL 5.x
• PostgreSQL
• VMware
• Cloud Computing
• Amazon RDS
• EC2 S3
• VPC EBS
• AWS DMS
• DynamoDB
• Azure SQL Database/Managed Instance
• Elastic Pools
• Azure IaaS/PaaS
• Azure Cache for Redis
• PowerShell
• ServiceNow.

PROFESSIONAL EXPERIENCE

Confidential

SQL Server Solutions Architect/Cloud Engineer

Responsibilities:

• Support several clients modernize their infrastructure leveraging public cloud hosting services (IaaS, PaaS), and platforms such as AWS and Azure.
• Provide subject matter expertise (SME) for the design, configuration, support and maintenance of Microsoft SQL platform. Design and implement robust solutions to improve database workload performance, scalability, and reliability, leveraging multi-site capabilities that are available in AWS and Microsoft Azure. Define and maintain the standards, procedures, design and storage configurations for all database systems.
• Perform hands on administration and systems engineering of the IT infrastructure to assure that systems meet or exceed business needs and expectations. Analyze system requirements and define system architecture that will meet business needs, including network/storage/compute infrastructure, capacity planning, protocols, and systems security.
• Implement and maintain security measures based on Security Technical Implementation Guides (STIG), to ensure the database environment is compliant with client’s requirements. Design and implement automated process to sync database backups in S3 buckets are cross-region replicated, to align with data recovery SLA.

Environment: Windows 2012 R2/2016/2019, MS SQL Server 2016/2017/2019, Azure IaaS/PaaS, Azure Data Factory, Azure SQL database geo-replication.

Confidential

Senior Database Administrator/Cloud Engineer

Responsibilities:

• Manage SQL Server systems through multiple product lifecycle environments, from development to mission-critical production systems. Design, architect and develop data management solutions using modern cloud platforms such AWS or Azure to ingest and enrich data in transit and at rest. Work with large scale network, compute and storage architectures to help remove roadblocks in customer migration projects. Deploy AWS infrastructure for scalability, availability, reliability, security, and performance within AWS managed services environment to meet customer SLA. Extensive knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server workloads in geographically diverse environments. Lead efforts to migrate multi-TB sized databases to AWS RDS instances leveraging AWS DMS or native backup to S3 method.
• Provide architecture and design recommendations and guidance to customers based on industry best practices around advanced cloud-based solutions, and how to migrate existing workloads to the cloud. Analyze complex systems to determine performance bottlenecks, application bugs, and opportunities to improve efficiency. Develop large-scale data transformation processes including cross-platform data migrations. Develop and drive technical solutions to existing and future database related restrictions or problems and addresses potential limitations in a proactive manner.

Environment: Windows 2012 R2/2016, Linux, AWS EC2, RDS, S3, DMS, SQL Server 2014/2016/2017, Multi-AZ Availability Groups.

Confidential, Pasadena, CA

Senior Database Administrator - Team Lead

Responsibilities:

• Maintain and support large-scale database architectures across multiple data centers. Analyze system and database performance, health checks and implement tuning improvements.
• Maintain indexes and statistics using scheduled maintenance plans. Define and implement company’s database strategy by analyzing the database requirements of the supported business systems and designing a database infrastructure to support the business objectives. Perform installations and upgrades on all SQL Server versions, including SQL Server standard and AlwaysOn clusters
• Collaborate with software architects to gather requirements to develop effective database solutions.
• Plan and implement proper HA/DR solutions for critical business systems utilizing AlwaysOn Availability Groups. Analyze emerging industry and database technology trends translating implications for new capabilities within functional and technology domains. Develop and maintain detailed documentation relating to procedures, processes and standards. Implement changes to database schemas and master data; enforce policies for releasing changes into production.
• Lead efforts in code/database migration, database change management, data management and T-SQL code review during key points of the SDLC process. Work with storage and systems engineers to develop requirements for Microsoft SQL server hardware configuration, including disk layout, raid levels, memory requirements, etc. Design database systems to support applications, ensuring system scalability, security, performance and reliability. Run diagnostics as required, and automate operational processes using T-SQL and PowerShell scripts.

Environment: Windows Server 2008 R2/2012 R2, SQL Server 2008 R2/2012/2014/2016, SolarWinds DPA for SQL Server, Dell Compellent, TFS, .NET, VMware, PowerShell, Extended Events.

Confidential - Hollywood, CA

Senior Database Administrator

Responsibilities:

• Provide high-level support for over 300 instances of SQL Server 2000/2005/2008 across the enterprise. Install and upgrade over 50 SQL Server 2005/2008 clusters.
• Ensure database availability in a production environment, including backups and disaster recovery.
• Maintain service packs and patches for release management and enforce security policies.
• Meet with internal groups and end-users to gather high-level and detailed information needed to scope out proposed applications, reporting systems and/or enhancements to existing systems from a database and data warehousing perspective. Maintain documentation related to database server configuration and database change management.
• Ensure all database releases were properly assessed and measured from a functionality and performance perspective.
• Large-scale data manipulation and extract transform and load (ETL) using SSIS packages, T-SQL code and other techniques. Plan and implement various mission critical database applications migration to another data center with great success.

Environment: Windows Server 2000/2003/2008, SQL Server 2000/2005/2008/2008 R2, Idera Diagnostic Manager, Red Gate SQL Backup, JIRA, MySQL 5.x, SAN, and VMware.

Confidential - Los Angeles, CA

Senior SQL Server DBA

Responsibilities:

• Install and configure software and hardware for SQL Server development and production environments. Deploy and manage database maintenance plans; design and implement backup/restore automated tasks. Define and enforce database standards, policies, security and documentation. Diagnose problems using tools such as SQL Profiler and System Monitor, work with vendors and developers as needed to resolve issues. Design and implement complex ETL/SSIS processes. Data mapping and conversion change control and bug fixes.
• Maintain in excess of 50 instances of SQL Server 2000/2005 across multiple data centers. Maintain an ongoing configuration design and documentation for the databases. Management of the database environment by defining database maintenance tasks, such as backup/restore, indexing, statistics, alerts and notification for database servers. Apply latest SQL Server service packs and hot fixes to ensure maximum security. Had an active role in building the first data warehousing system utilizing SQL Server 2005.
• Designed and configured a SQL Server 2005 cluster system to be used by an internal trouble ticket tracking application (HEAT) by more than 300 users. Upgraded number of production servers from SQL 2000 to 2005. Developed and implemented Disaster Recovery (DR) on production SQL Server 2000/2005 clusters. Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts.

Environment: Windows Server 2000/2003, SQL Server 2000/2005.