We provide IT Staff Augmentation Services!

Sr. Cloud Solution Engineer Resume

Lake Mary, FL

SUMMARY

  • Performance - driven and accomplished Microsoft Certified Solutions Expert with over ten years of diversified experience and success in the design, development, deployment, and administration of database systems using Microsoft SQL Server 2005-2016.
  • An AWS Certified Solutions Architect - Associate who bridges the gap between technology initiatives and corporate goals with proven success in leveraging cloud and database technologies to drive business growth and expansion.
  • Proven success in Microsoft SQL Server database administration and development, DTS/SSIS and ETL development (triggers, DTS/SSIS packages, stored procedures, functions, views, temporary tables, table variables, etc.)
  • Extensive experience in full project lifecycle development for implementation and integration
  • Recognized for delivering high database integrity and performance by overseeing database tuning, backup, replication, and capacity planning while guiding developers
  • Track record of consistently exceeding goals by expertly managing and refining project management strategies
  • Excellent leadership skills including issue management, conflict resolution, business and process analysis, team building and staff management
  • Strong technical knowledge and experience in project management, business analysis, service transitions and technology adaptation, leading directly to increased productivity and profitability
  • IDAP - Hadoop Integrated Data & Analytics Platform

TECHNICAL SKILLS

Application Software: Microsoft Office Suite, Access, SQL Server Management Studio, .SQL Server Integration Services, SQL Server Reporting Services, Visual Studio 2010-2013, SQL Server Data Tools 2010-2015, SentryOne Performance Manager, Jenkins CI

Languages: Visual Basic, C#, SQL, T-SQL

Databases: MS SQL Server 2000/2005/2008 R2/2012, 2014, 2016

PROFESSIONAL EXPERIENCE

Confidential, Lake Mary, FL

Sr. Cloud Solution Engineer

Responsibilities:

  • Managed over 300 SQL Server EC2 environments in Amazon Web Services.
  • Provisioned AWS RDS and EC2 instances, VPC, Internet Gateways/Subnets etc…
  • Provisioned AWS storage (gp2, io1, st1, instance store) for application and database servers
  • Configured VPC endpoints, VPC peering, CloudWatch Alarms
  • Ensure all database servers are backed up in a way that meets our client’s Recovery Point Objectives (RPO)
  • Ensure high availability and meet SLAs for production systems
  • Installed and configure new SQL Server per best practices in performance and security
  • Ensures optimal database performance through exhaustive preservice testing and ongoing real-time monitoring
  • Conducts benchmark tests to gauge hardware capacity and meet application capacity requirements.
  • Performed systems analysis and design; rewrote long running queries, stored procedures, and created missing indexes
  • Implemented database auditing to monitor data definition language events such as creating, dropping, and altering database objects

Confidential, Sunrise, FL

Sr. Database Administrator/Architect

Responsibilities:

  • Consolidated several enterprise SQL Servers resulting in over $500,000 annual savings (licenses costs) for the DCM project and over $300,000 savings (licenses costs) annually for the DR project
  • Generated over $200,000 savings (licenses cost) annually by virtualizing several application and SQL Server environments
  • Minimized disruption of business activities by coordinating data center migration and disaster recovery for all SQL Servers
  • Tuned databases to optimize storage and minimize server processing, leading to improvements in DB performance
  • Performed systems analysis and design; rewrote long running queries, stored procedures, and created missing indexes
  • Implemented database auditing to monitor data definition language events such as creating, dropping, and altering database objects
  • Implemented best practices during the installation, configuration, and migration of SQL Server, Integration Services, and Reporting Services
  • Implemented performance counters to monitor deadlocks, cache hit ratio, buffer management

Confidential, Miramar, FL

Database Engineer Consultant

Responsibilities:

  • Virtualized a client (Miami Dade College) SQL Server environment, resulting in significant cost savings while increasing productivity and performance
  • Developed an innovative database strategy to enable growth and scalability while minimizing potential risk and costs
  • Oversaw the management and maintenance of production and non-production SQL Server databases
  • Minimized technical support issues by developing training, upgrade and procedural documents for clients
  • Developed high availability (failover clustering, database mirroring, etc.) and replication strategies
  • Provided onsite database consultation for SQL Server migration to VMware, Clustering, etc.
  • Developed cost effective solutions for database creation, migration, replication and disaster recovery
  • Provided technical support to developers, prepared data models and monitored data availability
  • Assessed and planned SQL Server migration to VMware while optimizing data warehouses
  • Developed statement of work (SOW) for clients and created VMware/SQL Server best practice template for clients

Confidential, Hollywood, FL

Database Administrator

Responsibilities:

  • Developed the Tribe's first IRS 1099-MISC tax system - reporting millions of dollars in expense to the IRS annually
  • Led the development and implementation of the company’s first Tribal Member Statement of Benefits - reporting millions of dollars in expense benefits to Tribal members semi-monthly and annually
  • Provided key leadership to all aspects of the database administration process, ensuring their availability and security
  • Administered Lawson, ArcGSI, Sungard Jail Management Systems (OSSI JMS) and Record Management System (OSSI RMS)
  • Optimized stored procedures & long running queries by analysing query plans, IO Statistics, and Joining Techniques
  • Provided primary SQL Server support for multiple environments (design, development, test, support and production)
  • Created and ran Ad-hoc Reporting Services reports against enterprise applications for end users

Hire Now