DATABASE DEVELOPER

Svitla Systems Inc. is looking for a Database Developer for a full-time position (40 hours per week) in Colombia. Our client offers a comprehensive suite of billing, payments, and software solutions for legal, accounting, and other professional services firms, including consulting, architecture, and engineering. The mission is to simplify complex processes by integrating technology and automation into workflows, enabling businesses to focus more on their core services. The platforms are designed to facilitate seamless invoicing, payment processing, and client management, allowing companies to increase revenue and enhance client satisfaction. These robust, easy-to-use solutions enable firms to increase their billable time, get paid faster, automate invoicing and payments, integrate systems, go paperless, and more. The portfolio of products boasts on-premise software, cloud-based, and mobile features available across devices, supported by award-winning customer service based in the United States. Requirements: 5+ years of professional experience in database design and development using Microsoft SQL Server (2012/2016/2019). Advanced knowledge of T-SQL, database functions, indexing, and query optimization. Experience with SSIS for creating ETL solutions and handling complex data integrations. Strong understanding of database performance tuning, execution plan analysis, and troubleshooting database-related issues. Familiarity with data modeling concepts, schema design, and normalization techniques. Hands-on experience with data visualization tools like Power BI to develop interactive and actionable dashboards. Solid understanding of database security, roles, and permissions. Experience working with Azure SQL Database or other cloud-based database systems (preferred). Strong written and verbal communication skills with the ability to work collaboratively in a team environment. Nice to have: Bachelor's degree in Computer Science, Information Systems, or a related field. Microsoft Certification(s) such as MCSA: SQL Server or Azure Database Administrator Associate. Familiarity with scripting languages such as Python or frameworks like .NET to support database-related development. Responsibilities: Design, develop, and maintain robust database solutions using Microsoft SQL Server to meet business needs. Write, optimize, and troubleshoot complex T-SQL queries, stored procedures, user-defined functions, views, and triggers. Design ETL workflows and data pipelines using SSIS (SQL Server Integration Services) to integrate data from various sources. Analyze and improve database performance by implementing appropriate indexing strategies, monitoring execution plans, and resolving query bottlenecks. Develop and maintain database schemas, ensuring adherence to normalization principles and updated data models. Develop data visualization and reporting solutions utilizing tools like Power BI to deliver clear insights into business metrics. Lead efforts to ensure data integrity, consistency, and security throughout the database environment. Assist in database testing, debugging, and troubleshooting during application development phases. Work closely with business analysts and key stakeholders to gather data requirements and translate them into technical designs. Document database designs, workflows, and ETL processes. Ensure database standards and best practices are followed. Plan and execute database backup, restoration, and recovery strategies to ensure business continuity. About Svitla Svitla Systems is a global trusted IT solutions company headquartered in California, with business and development offices through out the US, Latin America, Europe, and Asia. Svitla is an outspoken advocate of workplace flexibility, best known for its well-established remote culture, individual approach to our teammate’s professional and personal growth, and welcoming environment. Since 2003, Svitla has served a wide range of clients, from innovative start-ups in California to mega-large corporations such as Ingenico, Amplience, InvoiceASAP and Global Citizen. At Svitla, developers work with clients’ teams directly, building lasting and successful partnerships, as a result of seamless integration with on-site processes. Svitla Systems’ global mission is to build a business that contributes to the well-being of our partners, personnel and their families, improves our communities, and makes a lasting difference in the world. Join us If you are interested in our vacancy, just click "Apply". We will be happy to see you in our friendly team :) #J-18808-Ljbffr