Resume

Sign in

Data Sql Server

Location:
Hamilton, Ontario, L8P 1X6, Canada
Salary:
50000
Posted:
January 31, 2018

Contact this candidate

Rafael Bahia Leandro

Hamilton – ON – Canada

Mobile: +1-905-***-****

Email: ac396f@r.postjobfree.com

LinkedIn: https://www.linkedin.com/in/rafael-bahia-leandro-98434818/

PROFILE SUMMARY

I am a focused and results-oriented IT professional with more than nine years of experience. Within those years, I have helped both companies and individual developers get the most of their database setups, guaranteeing performance and stability. I prefer simple and intuitive solutions. At the same time, I like to dedicate time to learn new technical and soft skills in order to further enhance my abilities. My core technical skills involve (non)relational Database Management (full stack), BI, Big Data Analysis and Programming. My personal skills include easy adaptation to new challenges and scenarios, hard work, effective communication, humility and attention to details.

My Microsoft Certified Professional profile: http://www.mycertprofile.com/Profile/442-***-****

My GitHub portfolio (WIP): https://github.com/rbleandro

CAREER HISTORY

Database Administrator, Via Varejo SA, São Paulo, Brazil

40 hours per week, 2009/11 to present date (Current occupation)

End-to-end implementation of data-driven solutions: analysis, architecture, deployment, security, auditing, backup/restore strategy, disaster recovery, high availability and day-by-day maintenance and monitoring

Provide support for Cloud deployments and migrations (IaaS, PaaS and SaaS)

Extract data to build predictive models using machine learning to support business decisions, database tuning and hardware provisioning

Strong knowledge about the best practices of SQL coding, ensuring fast performance queries and reports. Ministered several workshops to disseminate these best practices and good standards on data access

Perform code review activities to proactively detect code deficiencies before they go to production environments, while identifying and rewriting poor performing SQL code already in production

Maintain and improve (non)relational database models both conceptual, logical and physical to avoid data duplication and redundancy, reduce space consumption, address issues like wrong indexing strategies and data types misuses, and provide developers with a clear picture of tables’ relationships

Design and maintain ETL packages to CRM databases and across other database platforms such as Oracle, MySQL and SQL Server using SSIS and Python. Experience with data munging, data wrangling and data life cycle management

Use advanced synchronous and asynchronous solutions such as CDC and Change Tracking to integrate the database with other data platforms and search engines like MongoDB, Apache Kafka and Solr

Support management teams to set priorities and ensure timely delivery of projects using both Waterfall and Agile methodologies (Scrum, Kanban)

Automate database health checks and performance counters extraction using scripting languages such as PowerShell, VBS and command prompt in order to anticipate problems and establish performance baselines

Configure TFS to provide database versioning in order to make tracking of object and data change possible, allowing developers to quickly rollback any undesirable changes and enabling faster and more secure deliveries

Develop database continuous integration and delivery to production (DatabaseOps), while keeping staging, testing and development environments always up to date with the main database

Document database using documentation tools such as SQL Doc and MS Office to give the developers insight about dependency between database objects (tables, procedures, functions, constraints, etc.) and to comply with SOX auditing demands.

Web Developer, Bessora Institute, Rio de Janeiro, Brazil

20 Hours per Week, 2009/10 to 2014/12

Develop and maintain a web site using Front and Back End technologies (CSS, HTML, JavaScript, Ajax, MySQL, PHP and WordPress)

Solve connectivity and bad performance issues within the whole architeture

Identify and correct code smells and bugs

Database Administrator (Intern), BRQ IT Services, Rio de Janeiro, Brazil

20 Hours per Week, 2008/10 to 2009/11

Maintained database models to ensure compatibility with Normal Forms

Automated basic administrative tasks

Supported development teams with SQL development and database modeling

SPECIAL CARREER ACHIEVEMENTS:

Actively supported 6 Black Friday and other big retail/ecommerce events in which the databases performed as expected, serving millions of simultaneous requests for extended periods of time without going offline and allowing the achievement of the established business targets

Successfully deployed and administered dozens of ecommerce/retail databases simultaneously, while addressing the intricacies of each business needs

EDUCATION & TRAINING

Institution: Data Science Academy

Major: Data Scientist Program

Degree: Diploma

Course Outline: ML, Deep Learning, Hadoop Ecosystem, Spark, Python, R, Statistics, Cloud

Location: São Paulo, Brazil

Link: www.datascienceacademy.com.br/

In progress

Institution: Unicarioca University Centre

Major: Systems Analysis and Development

Degree: Bachelor

Location: Rio de Janeiro, Brazil

Link: https://www.unicarioca.edu.br/

2007/01 to 2010/06

Year Awarded: 2014

Institution: CCAA

Major: English Talking and Writing Proficiency

Degree: Diploma

Location: Rio de Janeiro, Brazil

Link: https://www.cclsmiami.edu/

2006/01 to 2009/01

Year Awarded: 2009

Institution: ESPCEX

Major: General Studies and Military Science

Degree: High School

Location: Campinas, São Paulo, Brazil

Link: http://www.espcex.eb.mil.br/

2005/01 to 2006/01

Year Awarded: 2006

PROFESSIONAL MEMBERSHIPS

MCP (Microsoft Certified Program). Membership awarded for the following certifications:

Microsoft Certified Solutions Associate: SQL 2016 Business Intelligence Development

Microsoft® Certified Solutions Expert: Data Management and Analytics

Microsoft® Certified Solutions Expert: Data Management and Analytics – 2016

Microsoft® Certified Solutions Associate: SQL Server 2012 (MCSA)

Microsoft® Certified Solutions Expert: Data Platform (MCSE)

Microsoft® Certified Professional

Microsoft® Certified IT Professional: Database Developer 2008

Microsoft® Certified Technology Specialist: SQL Server® 2008, Database Development

Microsoft® Certified IT Professional: Database Administrator 2008

Microsoft® Certified Technology Specialist: SQL Server® 2008, Implementation and Maintenance

MAIN IT SKILLS

IT Skills: SQL Server (Full Stack), Oracle, IBM DB2, Python, MongoDB, VBS, PowerShell, TFS, Visual Studio, Erwin Data Modeler, ER/Studio Data Modeler, Windows, LINUX, Microsoft Office: Word, Excel, PowerPoint, Outlook, Access

OTHER IT SKILLS

Spark, Hadoop, HDFS, Sqoop, Pig, Hive, Kafka, R, CSS, HTML, Scrum, Kanban, WordPress

LANGUAGES SKILLS

English – full conversational and work proficiency; Portuguese – mother tongue



Contact this candidate