DBA

Position: Lead Software Engineer 

Job Overview:

Lead ETL Engineer with SSIS (SQL Server Integration Services) knowledge is primarily responsible for designing, developing, and maintaining ETL (Extract, Transform, Load) workflows and data integration processes to support enterprise data solutions. 

Key Responsibilities and Duties  

Lead the software development team: 

• Lead a team of software engineers in designing, developing, and maintaining ETL Framework. 
• Set and communicate clear expectations for the clients regarding project timelines, quality standards, and deliverables. 
• Experience with Microsoft SQL Server Database, 
• Hands-on experience in writing, optimizing and maintaining complex SQL queries, stored procedures and functions. 
• Design and develop robust, scalable, and efficient database structures based on the organization's requirements. 

SSIS: 

• Design, develop, test, deploy, and maintain SSIS packages for data migration, ETL processes, reporting and to integrate data between various systems. 
• Develop complex SQL queries to extract data from various sources such as Oracle or SQL databases. 
• Troubleshoot issues related to package execution failures and optimize performance of existing packages. 
• Collaborate with stakeholders to understand business requirements and design solutions using SQL Server Integration Services (SSIS). 
• Work closely with the team to ensure timely delivery of projects. 
• Optimize existing integrations for improved performance and scalability. 
• Design and implement complex SSIS packages for extracting, transforming, and loading data from various sources such as relational databases (SQL Server, Oracle, DB2), flat files, and XML files. 
• Develop ETL best practices, including error handling, logging, checkpoints, and data quality assurance. 
• Write efficient SQL queries, stored procedures, functions, and triggers to support ETL processes. 
• Optimize SSIS packages and SQL queries for maximum performance using techniques such as parallelization, lookup caching, and bulk loading. 
• Create and maintain design documentation such as data models, mapping documents, data flow diagrams, and architecture diagrams. 
• Collaborate with business analysts, BI teams, and other stakeholders to understand requirements and deliver data solutions for reporting and analytics. 
• Schedule and monitor SSIS workflows using SQL Server Agent or other scheduling tools, ensuring timely and error-free data loads. 
• Troubleshoot, debug, and test SSIS packages and backend database processes to ensure data accuracy and system reliability. 
• Participate in resource planning, task estimation, and code review processes. 

Collaborate with cross-functional teams: 

• Work with other teams such as product management, quality assurance, and user experience to ensure that software applications meet business requirements and user needs. 
• Communicate effectively with team members and stakeholders. 

Stay up to date with emerging trends and technologies: 

• Keep up to date with emerging trends and technologies in the software development industry. 
• Make recommendations for improvements to existing software applications and processes. 

Mandatory skills 

SSIS, understanding of ETL Framework, able to design and implement SSIS 

Qualifications 

• Bachelor’s degree in computer science or related field. 
• 6-9 years of experience in software development. 
• Proven leadership experience in leading ETL teams. 
• Knowledge of software development methodologies such as Agile or Scrum. 
• Ability to mentor and train junior team members. 

• Design, build and deploy effective SSIS packages to validate, synthesize, transform customer data for integrated business planning and analytics
• Understand platform’s data model (table structures, linkages, optimal designs) for designing various planning use cases
• Review and analyse the data provided by customers along with its technical/functional intent and interdependencies
• Participate in the technical design, data requirements gathering and making recommendations on best practices, in case of inaccurate or missing data
• Design and automate the data loading and insights generation process with intelligent checks and balances for sustained value delivery
• Create and execute test plans,document issues and track progress at resolving issues.

• Manage different versions of complicate code and distribute them to different teams in the organization utilizing TFS.
• Develop an ASP.Net application to input and manage a production schedule, production statistical analysis and trend reporting.
• Create routines for importing data utilizing XML, CSV and comma delimitate files.
• Filter and cleanse OLTP data with complex store procedures and SSIS packages in the staging area.
• Develop a dimensional database and OLAP cube using SSAS for analysis, maintenance and good customer service.
• Involve in development and implementation of SSIS, SSRS and SSAS application solutions for various business units across the organization.
• Extract the data from XML and load it to dimensional model.
• Maintain SQL scripts, indexes, complex queries for data analysis and extraction.
• Create advanced reports like dashboard and scoreboard using SharePoint and power pivot for better presentation of data.
• Create cubes in SSAS reports which require complex calculations such as calculation of the premium for a particular policy.
• Create SharePoint sub sites, lists, libraries, folders and apply site permissions according to the given requirement.
• Work with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements.
• Develop T-SQL functions and store procedures to support complex business requirements.
• Create and configure an OLTP replication database for disaster recovery purpose.
• Designed/Implemented/Maintain OLAP servers and processes to replicate production data to the server.

• Over 2 years of Dynamics NAV consultancy experience/ Minimum 1 Yr experience in Business Central
• Strong understanding of Microsoft Dynamics NAV 2009/2013/2015/2016
• Undertake the design, coding, testing, releasing the code, and NAV / Dynamics 365 Business Central support
• Proficient in RDLC Report Development & SQL Server Database
• Experience working on the technical side of Dynamics NAV / Dynamics 365 Business Central
• Should be fluent and conversant with (A/L, C/AL & C/Side) Programming and ability to do developments independently
• Experience in working on full life cycle implementations across multiple versions of Dynamics NAV
• Excellent understanding and knowledge of core Microsoft Dynamics NAV modules
• Manage resources and deliver project tasks, both external and internal. 
• Communicate and document system specifications for clients and team members. 
• Manage multiple developments and project initiatives at one time, while effectively communicating utilization, roadblocks, and progress to technical leadership and prioritizing based on feedback.
• Strong understanding of Microsoft Dynamics NAV/BC and its modules.
• Strong analytical skills with an ability to diagnose problems quickly and recommend solutions
• Excellent time management skills and ability to meet deadlines and work under pressure

We are looking for a Senior Microsoft SQL Developer to design, develop, test, plan, implement and maintain conceptual and logical database models.

For this role, you should know how to analyze system requirements and implement migration methods for existing data. Hands-on experience with SQL Server 2012 and above is also required. Ideally, you are familiar with database design, reviewing code, writing stored procedures, creating and modifying SQL agent jobs, making structural changes to tables and views.

Ultimately, you will develop database solutions to ensure project information is stored effectively and securely.

We’re a fast-growing company with clients in the United States, UK, and Australia. You will join a team of talented developers, quality engineers, product managers whose mission is to impact above 100 million people across the world with technological services by the year 2030.

Working as Senior Microsoft SQL Developer at Navtech, you will:

1. Design conceptual and logical data models and flowcharts.
2. Improve system performance by conducting tests, troubleshooting, and integrating new elements.
3. Design and Build database systems of high availability and quality depending on each end user’s specialized role.
4. Help write and optimize in-application SQL statements.
5. Handle common database procedures such as upgrade, backup, recovery, migration, etc.
6. Ensure performance, security, and availability of databases.
7. Use high-speed transaction recovery techniques and backup data.
8. Provide proactive and reactive data management support and training to users.
9. Determine, enforce and document database policies, procedures, and standards.
10. Perform tests and evaluations regularly to ensure data security, privacy, and integrity.
11. Monitor database performance, implement changes, and apply new patches and versions when required.

1. 5+ years of experience in SQL Server Development with at least 1 year of Lead experience.
2. Advanced experience in database monitoring, troubleshooting, performance tuning, and high availability strategies for SQL Server 2016, SQL Server in Cloud (AWS RDS preferred).
3. Advanced skills in resolving database locking conflicts/blocking and resource utilization.
4. Ability to work with other developers and engineers to analyze database performance and identify problems in areas such as execution plans, index coverage, and SQL server statistics.
5. A thorough understanding of Performance Monitoring, Tuning, and Optimization, using native and third-party monitoring and troubleshooting tools.
6. Advanced knowledge of SQL Server Disaster Recovery (DR) options, Always On availability groups, and experience administering Windows Server, including Active Directory, Failover clustering, database partitioning, security, and encryption (a plus).
7. Experience supporting SSIS, SSRS, replication, database mirroring (a plus).
8. PowerShell scripting experience with the ability to write automated scripts and strong knowledge of system tables and DMV’s is required. (a plus).
9. Administering Microsoft SQL Server databases in a high transaction, 24x7 database environment (a plus).
10. Experience in Postgres, No-SQL databases (a plus).
11. MCSA SQL Server 2012/2016 , MCSE or MCDBA (a plus).
12. Should have excellent logical, analytical, and communication skills with client interaction experience.

Benefits

• Working with industry giants while following your passion for technology.
• Competitive pay package with additional bonus and benefits.
• Performance review and Appraisal Twice a year.
• Family Health Insurance cover for self and family.
• Work with US, UK, and Europe-based industry-renowned clients for exponential technical growth.
• Work with a culturally diverse team from different geographies