Alejandro Chavarria
Senior Database Developer at Neighborhood House- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
Spanish Full professional proficiency
-
German Elementary proficiency
Topline Score
Bio
Credentials
-
Exam 762: Developing SQL Databases
MicrosoftJun, 2018- Oct, 2024 -
MCSA: SQL 2016 Database Development - Certified 2018
MicrosoftJun, 2018- Oct, 2024 -
Exam 761: Querying Data with Transact-SQL
MicrosoftNov, 2017- Oct, 2024 -
CompTIA Network+ Exam Prep (N10-006) Part 5: Advanced IP Networking
Lynda.comNov, 2015- Oct, 2024 -
CompTIA Network+ Exam Prep (N10-006) Part 6: Beyond the Typical Network
Lynda.comNov, 2015- Oct, 2024 -
CompTIA Network+ Exam Prep (N10-006) Part 7: Managing the Network
Lynda.comNov, 2015- Oct, 2024 -
Database Fundamentals: Core Concepts
Lynda.comNov, 2015- Oct, 2024 -
Foundations of Programming: Databases
Lynda.comNov, 2015- Oct, 2024 -
Foundations of Programming: Fundamentals
Lynda.comNov, 2015- Oct, 2024 -
Foundations of Programming: Object-Oriented Design
Lynda.comNov, 2015- Oct, 2024 -
Relational Database Fundamentals
Lynda.comNov, 2015- Oct, 2024 -
CompTIA Network+ Exam Prep (N10-006) Part 1: Understanding Networks
Lynda.comOct, 2015- Oct, 2024 -
CompTIA Network+ Exam Prep (N10-006) Part 2: The Physical Network
Lynda.comOct, 2015- Oct, 2024 -
CompTIA Network+ Exam Prep (N10-006) Part 3: The World of TCP/IP
Lynda.comOct, 2015- Oct, 2024 -
CompTIA Network+ Exam Prep (N10-006) Part 4: Making TCP/IP Work
Lynda.comOct, 2015- Oct, 2024
Experience
-
Neighborhood House
-
United States
-
Individual and Family Services
-
1 - 100 Employee
-
Senior Database Developer
-
Oct 2019 - Present
• Provide training and supervision to the Database Developer, ensuring design, coding, and documentation conventions are maintained• Conduct performance reviews for Database Developer and make recommendations for compensation adjustments• Oversee the prioritization of tasks for the Database Developer• Maintain and build new Microsoft Access databases with Microsoft SQL Server back ends• Design and create Microsoft SQL Server databases, tables (including triggers), views, functions, stored procedures• Write optimized T-SQL queries for reporting• Build and maintain SSIS ETL packages for application integrations and data warehousing• Conduct research, set up demos, assist in procurement, and make recommendation for external data systems and other IT software (eg. HR HMIS, payroll processing, timesheet, CMS for social service organizations, employee engagement software, emergency notification system, etc.)• Direct implementation of new data systems and assist in the implementation of new IT software• Upgrade existing and install new SQL Server instances as needed• Monitor performance of SQL Server databases and instances• Develop and maintain security models to ensure data segregation in Microsoft SQL Server and Microsoft Access databases• Configure, maintain, monitor, and test robust backup and recovery plans and procedures for Microsoft SQL Server databases, instances, and hardware as well as Microsoft Access databases• Make recommendations regarding the purchase of additional hardware to improve performance• Partner with internal stakeholders and customers to establish strategies for meeting changing database needs, documenting requirements and generating functional and technical specifications• Develop protocols and conventions for data processing and database design and ensure new projects meet business standards and requirements• Create administrative and user documentation for new and existing databases Show less
-
-
Database Developer
-
Jun 2019 - Oct 2019
• Maintain and build new Microsoft Access databases with Microsoft SQL Server back ends• Design and create Microsoft SQL Server databases, tables (including triggers), views, functions, stored procedures• Write optimized T-SQL queries for reporting• Build and maintain SSIS ETL packages for application integrations and data warehousing• Conduct research, set up demos, assist in procurement, and make recommendation for external data systems and other IT software (eg. HR HMIS, payroll processing, timesheet, CMS for social service organizations, employee engagement software, emergency notification system, etc.)• Direct implementation of new data systems and assist in the implementation of new IT software• Upgrade existing and install new SQL Server instances as needed• Monitor performance of SQL Server databases and instances• Develop and maintain security models to ensure data segregation in Microsoft SQL Server and Microsoft Access databases• Configure, maintain, monitor, and test robust backup and recovery plans and procedures for Microsoft SQL Server databases, instances, and hardware as well as Microsoft Access databases• Make recommendations regarding the purchase of additional hardware to improve performance• Partner with internal stakeholders and customers to establish strategies for meeting changing database needs, documenting requirements and generating functional and technical specifications• Develop protocols and conventions for data processing and database design and ensure new projects meet business standards and requirements• Create administrative and user documentation for new and existing databases Show less
-
-
Database Programmer
-
Feb 2016 - Jun 2019
I manage all of the major data systems and build custom applications and databases using Microsoft SQL Server. I have worked on data migrations, integrations and architecture.-Design stable, reliable and effective databases-Optimize and maintain legacy systems-Modify databases according to requests and perform tests-Solve database usage issues and malfunctions-Improve applications and establish best practices-Gather user requirements and identify new features-Develop technical and training manuals-Provide data management support to users-Ensure all database programs meet company and performance requirements-Research and suggest new database products, services and protocols-Configure database servers-Monitor and maintain system health and security-Design backup processes for server and associated data-Create accounts for all users and assign security levels-Establish a disaster recovery protocol-Provide end-to-end technical support and problem resolution Show less
-
-
IT Support Specialist
-
Jun 2015 - Feb 2016
Troubleshoot various desktop user issues in a Windows 7 and Office 2010 environment.Assist users with mobile device/smartphone setup (email, etc.)Perform maintenance and troubleshooting on printers and other office equipment.Assist with inventory and asset management including tagging new hardware and maintaining inventory lists.Provide video conference and a/v support for meetings and events.Provide support for other technical systems such as locks/key cards, VOID phone system (ShorTel).Assist with IT administration tasksAssist with desktop software installation, troubleshooting and repair.Setting up new users on networks.Perform network maintenance as needed.Strong customer service skills, ability to identify a problem with a customer and provide solutions with excellent follow up. Show less
-
-
Assistant Preschool Teacher
-
Feb 2015 - Jun 2015
As a staff member of Neighborhood House's Child Development Department I contribute to the school readiness of low-income children and support their parents, care givers and community. My primary responsibility is to provide the highest quality early childhood education services with the overall goal of building a child's social competency.My responsibilities include:-Actively participating in the planning, implementation and evaluation of a creative classroom utilizing the Tools of the Mind curriculum-Assisting in creating a safe learning environment reflecting the diverse backgrounds of the participating families, most of whom have strong familial ties to East Africa-Involving parents in the classroom in meaningful ways which demonstrates the belief that parents are the principal influence on their child's education and development Show less
-
-
-
-
Long-Term Substitute Preschool Teacher
-
Apr 2014 - Jun 2014
My responsibilities include designing a preschool curriculum that encourages choice making, problem solving, kindergarten readiness, social/emotional development and pre-academic growth. My responsibilities include designing a preschool curriculum that encourages choice making, problem solving, kindergarten readiness, social/emotional development and pre-academic growth.
-
-
-
KIPP San Jose Collegiate
-
United States
-
1 - 100 Employee
-
High School Spanish Teacher
-
Jul 2011 - Jun 2013
-Differentiated instruction for both Second Language Learners as well as Heritage Language Learners within the same classroom -Established the school’s first Spanish class exclusively for Heritage Language Learners and developed its curriculum -Utilized TPR (Total Physical Response) methods to deliver engaging instruction -Presented professional development to school staff regarding my use of a entrance ticket data-tracking and targeted intervention system -Provided regular before- and after-school tutoring to individual and small groups of students in need of remediation -Wrote approved CSU/UC Course descriptions for the Spanish 2 and Spanish 3 classes -Presented information regarding student GPA calculation, California college/university eligibility requirements, SAT/ACT testing and AP classes offerings to Spanish-speaking parents -Translated from English to Spanish and facilitated “Student Success Meetings” for students failing two or more courses each semester -Supervised students on multiple community service events off-campus throughout each school year -Attended the AP Spanish Language conference Show less
-
-
-
Ithaca College
-
United States
-
Higher Education
-
700 & Above Employee
-
Spanish Teaching Assistant
-
Aug 2008 - May 2010
-Drill students with vocabulary and verb conjugations to reinforce concepts taught by professor. -Prepare students for upcoming quizzes or exams. -Answer students' questions concerning class material. -Drill students with vocabulary and verb conjugations to reinforce concepts taught by professor. -Prepare students for upcoming quizzes or exams. -Answer students' questions concerning class material.
-
-
Education
-
2007 - 2011
Ithaca College
Bachelor of Arts (B.A.), Spanish Language and Literature
Community
