Andrew Balira Email & Phone Number

Minneapolis, Mn, Us

San Antonio, Texas, United States

• Led the design and development of Microsoft SQL Server databases, including schema design, data modeling, and database architecture using SQL Server Management Studio (SSMS).• Optimized T-SQL queries, stored procedures, and database code within Microsoft SQL Server, leveraging SSMS tools like query execution plans and indexing strategies to enhance performance and minimize response times.• Developed and maintained ETL (Extract, Transform, Load) processes within SQL Server Integration Services (SSIS) to facilitate data integration and transformation between systems.• Created automation scripts and workflows using Transact-SQL (T-SQL) and PowerShell to streamline database tasks such as backups, deployments, and monitoring within SSMS.• Utilized SSMS for monitoring database performance metrics, proactively identifying and troubleshooting database-related issues to minimize downtime and ensure system reliability.• Collaborated with software developers, data analysts, and system administrators to integrate Microsoft SQL Server database solutions into applications and systems, ensuring alignment with business objectives.

Chanhassen, Mn

• Led the management and optimization of Oracle databases, including performance tuning, backup and recovery strategies, and ensuring data integrity and security.• Successfully migrated on-premises Oracle databases to the AWS cloud platform, leveraging services like EC2 with Oracle database instances.• Architect Oracle database solutions in AWS, designing for scalability, high availability, and disaster recovery using AWS services such as Multi-AZ deployments, read replicas, and AWS Backup.• Implemented Continuous Integration/Continuous Deployment (CI/CD) pipelines for database changes, integrating with version control systems and automation tools.• Implemented and enforced database security measures in AWS, utilizing IAM (Identity and Access Management), VPC (Virtual Private Cloud) security groups, and encryption-at-rest and in-transit to meet compliance requirements.• Implemented automation scripts and infrastructure as code (IaC) using Terraform to provision and manage database infrastructure, ensuring consistency and reproducibility.• Collaborated with development and DevOps teams to integrate database changes into CI/CD pipelines, providing expertise in database schema management and version control.

• Collaborated with senior developers to design and develop user-friendly interfaces using HTML, CSS, and JavaScript frameworks like React or Vue.js.• Ensured websites and web applications were responsive and optimized for various devices and screen sizes, utilizing media queries and responsive design techniques.• Supported backend development tasks using technologies like Node.js, Python/Django, or Ruby on Rails, assisting with API integrations and server-side logic.• Identified and troubleshooted frontend and backend issues reported by users or QA testers, working closely with the development team to implement timely solutions.• Use Git for version control, actively participate in code reviews, and collaborate with team members through platforms like GitHub or GitLab.• Continuously expand knowledge of web development technologies and best practices through self-study and training, applying new skills to enhance project work.• Conducted unit testing and assisted with user acceptance testing (UAT) to ensure the quality and reliability of web applications before deployment.

• Answer customers' questions about products, prices, availability, or credit terms.• Emphasize product features based on analyses of customers' needs and on technical knowledge of product capabilities and limitations.• Select the correct products or assist customers in making product selections, based on customers' needs, product specifications, and applicable regulations.• Collaborate with colleagues to exchange information, such as selling strategies or marketing information.• Demonstrate and explain the operation and use of products.

Helped customers in buying the very best computing device to handle their needsTaught customers on how to be able to use their new productHandled a variety of devices beyond computers such as mobile phones, TVs, car electronics, and cameras

Assisted the College of Nursing in upgrading their entire system to a new operating platform, Set up new computers and provided support to faculty and staff, Worked with a database that handled inventory of equipment