SQL Database Developer

FERNANDO RIOS DBA / DEV SQL SERVER

Dallas, TX +1-469-***-**** adw29o@r.postjobfree.com

EDUCATION

B.S. in Computer Systems Engineering, 2000 - 2004, GPA: 3.5/4 Technological of Higher Studies of Ecatepec, (TESE) Specialties: Databases, and Networks and Distributed Processes Postgraduate Diploma in Big Data as Business Strategy, 2019, GPA: 3.9/4 Technological Institute and Higher Studies of Monterrey, (ITESM) PROFESSIONAL EXPERIENCE

DB Development IT Leader - SOLERA HOLDINGS, 1/2021 - 1/2023

- Plan, organize and coordinate the required activities and new features for several corporate products to provide efficient continuity of the software dev cycle (Supervision Mechanisms, Strategic Planning).

- Developed hundreds of new features like SSRS reports, by using both SQL and SSAS queries, ETL projects in SSIS, and also processes in Stored Procedures by using both T-SQL and .NET CLR code.

- Generated analysis and troubleshooting with Prod servers, improving dozens of expensive processes going from tens of hours to a few minutes.

Development IT Leader - GBM STOCK GROUP, 12/2014 - 1/2021

- Designed, dev and deployment of 12 functional modules using C# with WCF, WPF, Docker, ASP.NET and T-SQL for the Record Keeping platform (RK), aligned within the Banking Core of the Brokerage Firm.

- Continuity of design, dev and deployment of 2 functional modules on Native Cloud Environment using C# in AWS Lambda, AWS Storage, CI/CD with CloudFormation.

- Integration and migration of 350 tropicalized old SQL Server databases into a new one in the cloud (SQL Server 2008 to AWS RDS SQL Server 2016, using ETLs).

- Monitoring, managing and optimizing the RK databases (SQL Server, Sentri tools, New Relic).

- Designed and optimized data storage and exploitation into splitted database engines (RDS, Aurora and DynamoDB).

- Built a custom authentication and authorization scheme for the RK Web App from scratch, including Google Federated sign-in and RK login with JWT.

SQL Server Consultant - EXTEND SOLUTIONS, 3/2011 - 12/2014

- Designed, dev and deployment of 4 module projects (using C# with WCF, WPF, CLR Functions and ETLs, SSRS) for the CFDI SAT Operations Project to automate administrative tasks, as well highly-customize of daily data consolidate for the daily data received from all taxpayers (processing about 10-12 GB of daily data) for later reporting.

- Built 4 automated processes with DWH data extraction and compute to generate daily executive reports.

- Part of the SQL DBAs staff, doing monitoring, management and provisioning SQL Azure instances, as well, setting up SQL Server HA environments as IaaS.

- Training was provided to 2 clients with specific needs related to both databases and the adoption of Agile Methodologies.

IT Engineer - HYETTE INTERCONTINENTAL TELECOM, 2/2010 - 3/2011

- Designed, dev and deployment of 2 apps (using PHP, Perl and PL-SQL) in Linux environment for the monitoring and management of remote VoIP equipment. It was possible to detect fraudulent VoIP traffic and take corrective actions in a few minutes through real-time data analysis and triggered alarms.

- DBA in charge of corporate database servers in the local country.

- Implementing Nagios as monitor, and performing query tuning in current and new corporate systems Sr VoIP Engineer - VoIP SERVICE, 2/2008 - 2/2010

- Designed, dev and deployment of 2 module apps (using PHP, Perl, Bash, and PL-SQL) for monitoring and management of remote VoIP appliances and their billing integration to corporate Nextone Softswitch, in Linux environment, and dev and maintain the corporate billing app, to automate bills and financial reports.

- Substitution of the Cisco Call Manager PBX with a low-cost PBX using Asterisk-based VoIP solution, with the savings of about $12,000 USD from licensing.

Developer / DBA / Infrastructure - ELECTRICAL TRANSPORTATION SERVICE, 2/2004 - 2/2008.

- Designed, dev and deployment of 7 module projects (using VB6 and C# and WinForms, SQL Server 2000 and Crystal Reports) for HR, Transport and Medical areas.

- DBA in charge of the servers of the Institution (SQL Server 97 and 2000). FERNANDO RIOS DBA / DEV SQL SERVER

Dallas, TX +1-469-***-**** adw29o@r.postjobfree.com Authorized To Work in The United States Page 2 of 2

- Installation and setup of 4 Yagi telecommunication antennas as bridges to expand the institutional network.

- Setup and management of Postfix Mail, FTP, IPSec and Nagios Servers. SKILLS

- Data: Data modeling, data analysis, creation of database objects, data normalization and denormalization Designing, implementing, managing and troubleshooting databases, fine-tuning of db objects to ensure efficient data retrieval

- BIDS Tools: Report creation using SSRS

ETLs using SSIS (pulling data from heterogeneous databases/data sources, data cleansing & transformation, to another databases and DWH, mass loads using bcp)

- Languages: T-SQL (complex T-SQL queries and routines in SP, Functions, Views, Triggers, to implement

the business rules and transformations)

C# .NET CLR (for specific functionalities not available in T-SQL and high-performance complex routines)

C# .NET creating backend business logic in APIs, Script Tasks in SSIS

- Platforms: SQL Server 2008 up to 2016, OnPrem & Cloud flavors (RDS AWS and Azure/SQL Azure)

- DB Administration: Data migration (from different sources / from OnPremise to Cloud) using SSIS Creation of full environments, management of security/roles/users/permissions Scheduled backups and restores of databases, changes deployment, error solving

- 3rd Party Tools: Sentryone for query tuning, Redgate and New Relic for monitoring and tasks automation

- Monitoring Database tools: Sentri, New Relic

- Other DBMS: MySQL, PostgreSQL, AWS Aurora, DynamoDB

- Version control: Git and TFS for both database and app code versioning

- Other Programming Languages: Perl, Bash, basic Python

- AWS Cloud Programming: Lambdas and API, Storage, JWT Auth, CI/CD, CloudFormation

- Azure Cloud Programming: Worker / Web roles, Storage

- Operating Systems: Windows, Linux

- Agile Methodologies

- Strategic Planning

- Spanish, English

AWARDS

National Creativity Contest, Winner in “Sales Category” with the project “Integral Management for Small Businesses” (GIPN), 2nd Place in 2006.

CERTIFICATIONS

- Microsoft Certification ID: 8847113

MSCITP (Cert. Number: D695-6712): Database Developer

MSCTS (Cert. Number: D976-4200): SQL 2012 Implementation and Maintenance

MSCTS (Cert. Number: D695-613): SQL Server 2012 Database Development

MCP (Cert. Number: E843-7484): Microsoft Certified Professional COURSES

- MCTS Stack: .NET SDK, ASP.NET, ADO.NET, WPF, WCF, WF - 2010

- Azure Storage & apps admin/monitoring, Azure async work loads, SQL Azure advanced topics - 2012

- Enterprise Information Management in SQL Server 2014, with MDS, DQS & BI Tools - 2014

- SQL Azure - Hands on troubleshooting - 2014

- Advanced query performance tuning - 2015

- Planning and designing databases on AWS - 2020

Contact this candidate