Database & AI-Driven Data Engineer - SQL & DW Expert

KENNETH RILEY

Database Administrator & Data Engineer • SQL, ETL/ELT, Data Warehousing, AI Data Engineering Portland, OR • 480-***-**** • ********@*******.*** • www.linkedin.com/in/rileykennneth PROFESSIONAL SUMMARY .

Experienced and results-driven Database Administrator and Data Engineer with over 10 plus years of expertise in designing, implementing, and managing complex database solutions for large-scale organizations. Strong proficiency in SQL Server/Azure and Data Warehousing architecture with a focus on performance optimization, data integration, business intelligence and AI assisted Implementations. Extensive experience leading the design and implementation of data warehouse solutions, including ETL/ELT processes and data modeling. Proven track record of enhancing data-driven decision-making through SQL, Power BI, and AI driven data solutions, while ensuring data security and compliance across multiple platforms.

. TECHNICAL SKILLS .

• Database Technologies: Microsoft SQL Server (2016, 2019, 2022, 2025), Microsoft Azure (Cosmos, SQL, MongoDB, MySQL, Oracle, PostgreSQL, SQL VM Instances), SSMS 22, Chat2DB, DataGrip

• ETL/ELT & Data Integration: SSIS, SSRS, SSAS, Azure Data Factory, SQL Data Links, Multi-Instance Database Management, Data Transformation, External Data Import (Medical Master Catalog, FCB, etc.), AI-assisted data validation and transformation

• Data Modeling: Erwin Data Modeler, T-SQL, Stored Procedures, Triggers, AI-assisted schema analysis and SQL development, MS Fabric

• Database Backup & Recovery: SQL Backup Strategies, Disaster Recovery (DR), Log Shipping, Mirroring, Always On Availability Groups

• Performance Optimization: Query Performance Tuning, Indexing, Partitioning, SQL Profiler, Extended Events, AI- assisted query analysis and performance tuning

• Database Security & Compliance: Enterprise Data Governance, Regulatory Compliance, Audit Logs, Encryption, Role-Based Access Control (RBAC), AI-supported audit review and compliance analysis

• Data Migration & Platform Upgrades: Application Database Migrations, Legacy to Modern Database Transitions, SQL Server Upgrades, AI-assisted impact analysis and migration planning

• Cloud Platforms: Azure SQL Database, AWS, Snowflake, AI-enabled cloud analytics and optimization

• Programming & Scripting: Python, JSON, XML, HL7, .NET, Visual Studio, HTML5, XML, JavaScript, AI-assisted scripting, automation, and code optimization

• BI & Reporting: Power BI, SSRS, Data Analysis & Reporting for Enterprise Applications, Tableau

• Agile/Scrum: Scrum Master, Sprint Planning, Agile Best Practices

• Project Management: PMI Methodology, Cross-Functional Collaboration, Change Management

• End-User Support & Troubleshooting: SQL Queries, ODBC Connections, SSMS, Error Resolution, AI-assisted issue diagnosis and resolution

• Office Tools: Microsoft Office Suite, Office 365, Teams, Excel (VBA intermediate), AI-assisted reporting and productivity tools

. PROFESSIONAL EXPERIENCE .

Freelance - Database Administrator SQL Server & Azure (remote roles) Contract Experience, DBA-Focused August 2025 – Present

• Administer and support SQL Server and Azure SQL platforms, including Azure SQL Managed Instance, Azure SQL Database and SQL Server on Azure Virtual Machines

• Perorm backup, restore and recovery operations, including point-in-time restores, DR validation

• Monitor and tune performance using Query Store, execution plans and wait statistics to support transactional as well as reporting workloads

• Design and implement high availability and disaster recovery solutions, including Azure-native capabilities and SQL Server Always On

• Manage database security and access controls, including Azure AD authentication, role-based access, encryption

(TDE), and auditing

• Support on-prem to Azure migrations using Azure Database Migration Service and modernization best practices

• Automated routine DBA tasks using PowerShell and Azure tooling to improve reliability and reduce manual effort

• Partner with application and reporting teams to ensure database stability, performance, and data integrity Senior SQL Server DBA Data Engineer FX Operation Analyst (one-site contract role) WELLS FARGO, Portland, OR July 2022 – February 2025

● Led database administration efforts for enterprise systems, ensuring high availability, performance tuning, and security compliance.

● Integrated SQL databases with enterprise applications, ensuring seamless functionality, security, and optimal performance.

● Managed SQL Server backups and disaster recovery strategies, implementing high-availability solutions such as Log Shipping, Mirroring, and Always On Availability Groups.

● Served as technical lead, managing database development, ETL processes, and system integrations across multiple platforms.

● Designed and optimized database schemas, collaborating with development teams to meet business requirements and regulatory compliance.

● Implemented Agile methodologies, acting as Scrum Master, facilitating sprint planning, backlog grooming, and process optimization.

● Collaborated cross-functionally with stakeholders and business units to resolve database issues, ensuring minimal operational disruptions.

● Performed security audits, routine upgrades, patches, and maintenance to optimize system performance and data integrity.

● Performed extensive SQL Server tuning, including indexing, partitioning, query optimization, and extended event tracing to enhance application performance.

● Mentored junior team members, providing technical training on SQL best practices, database administration, and troubleshooting techniques.

● Led migrations of legacy databases to modern SQL Server platforms, ensuring minimal downtime and seamless transition.

Senior SQL Server DBA Data Warehouse Consultant (hybrid contract role) ADVANTIS CREDIT UNION, Portland, OR January 2022 – March 2022

• Designed and tested T-SQL scripts for seamless data migration into SQL Server-based data warehouses.

• Developed complex SQL queries for data integration, supporting business intelligence and reporting (Power BI, SSRS).

• Managed Snowflake and Azure environments, ensuring scalable data storage and efficient retrieval.

• Supported cloud-based SQL environments (Azure SQL, Snowflake), ensuring scalability and security for financial data.

• Led UAT/SAT testing efforts for cloud-based database systems, ensuring compliance and security best practices.

• Executed data migration projects, transitioning application databases to optimized SQL Server 2019/2022 environments.

SQL Server DBA Data Analyst E-Business Consultant (hybrid role) Wells Fargo – San Francisco, CA March 2008 – April 2021

• Developed and maintained enterprise SQL Server databases, optimizing queries, stored procedures, and indexing strategies for improved performance.

• Led enterprise database performance tuning efforts, improving query execution and data processing speeds.

• Designed and maintained high-performance SQL Server VM instances supporting sensitive financial and regulatory data.

• Led ETL/ELT processes using SSIS, integrating data from multiple sources into Data Lakes and Warehouses.

• Developed and managed ETL workflows with SSIS, ensuring data integrity across multiple database environments.

• Integrated Power BI reporting solutions, providing real-time business intelligence and analytics for key stakeholders.

• Implemented database automation and workflow solutions, improving operational efficiency and reducing manual processes by 80%.

• Facilitated system enhancements and upgrades, ensuring minimal downtime during migrations and deployments.

• Supported large-scale SQL Server database environments, ensuring high availability and disaster recovery

(HA/DR) strategies.

• Led database migration and upgrades, managing security patches, performance tuning, and auditing processes.

• Developed complex SQL queries and procedures, optimizing data retrieval and transformation.

• Designed OLAP (MDX) solutions for large datasets, significantly improving BI reporting and decision-making.

. EDUCATION .

● Bachelor of Arts (BA), Saint Mary’s College of California, Moraga, CA

● Associate of Arts (AA), Diablo Valley College, Pleasant Hill, CA Certificate Programs:

● AI & Career Empowerment Certificate Program, University of Maryland

● Data Analytics Certificate Program, Portland State University, Portland, OR

● Database Administration Certificate Program, University of California, Berkeley, CA

Contact this candidate