Job Title: Database Developer (761389) Location: Atlanta, GA (Hybrid)
Duration: 12 Months *Send me the resumes to [email protected] <[email protected]>* *Job Description – * The ideal candidate must demonstrate in-depth knowledge and understanding of database concepts and be experienced in writing SQL and T-SQL. They need to support applications with24/7 availability and have experience handling large volumes of data in Oracle, SQL Server, and Azure SQL platforms. *Essential Duties and Responsibilities:* - Collaborate with internal customers, prospects, and stakeholders to understand and translate business use cases and requirements into data analysis and data mapping. - Develop data integration routines that involve moving, cleansing, and transforming large amounts of data between multiple systems. - Identify data sources, provide data flow diagrams, and document source-to-target mapping and processes. - Work with the Data Architect to recommend optimal data models for data ingestion and collaborate with the BI developer for analytic reports. - Provide technical enablement to team members developing database applications on a cloud platform. - Lead small teams of 1-2 junior developers in data integration efforts, utilizing ETL design patterns, error handling, and configurations. - Design, implement, and maintain database objects (tables, views, indexes, etc.) and database security. - Utilize Azure database tools and technologies, including Azure Data Studio and Azure Analytics Studio,to develop, maintain, and optimize database applications and solutions1. - Collaborate with data stewards, data owners, and domain experts to adopt best practices in reporting and analysis, ensuring data integrity, test design, validation, and documentation. - Optimize batch processing through parallelization and performance tuning to maintain data warehouse performance. - Establish processes for governing the identification, collection, and use of educational metadata to ensure accuracy and validity in business intelligence environments. - Ensure data quality through audit controls, proactive monitoring, and data cleansing techniques. - Troubleshoot performance and reliability issues and investigate anomalous behavior in the Azure environment. - Perform scheduled data process integrity checks, deployments, and coordinate releases. - Utilize source version control software like GitHub and CICD pipelines. - Provide on-call support after hours as needed. *Requirements:* - 7+ years of experience in data warehousing and business intelligence. - 5+ years in BI development leveraging Microsoft SQL Server, with expertise in T-SQL. - 5+ years in SSIS and use of stored procedures. - 3-5 years in Azure Data Factory, SQL VMs, and ETL development. - Experience in ingesting and aggregating data from internal and external sources to build a data lake. - Strong understanding of data modeling (conceptual, logical, and physical model design) and experience with operational data stores, enterprise data warehouses, and data marts. - Deep understanding of relational database design concepts and SQL programming. · Experience in guiding and mentoring developers with less experience. - Strong analytical, conceptual, and problem-solving abilities. - Experience with business intelligence and data warehousing design principles and industry best practices. *Good to Have:* - 1-2 years in Azure Data Warehouse (Synapse). - 1-2 years of experience utilizing Python, PySpark, and SparkSQL on Azure Cloud. *Qualifications:* - Bachelor's degree from an accredited college or university with coursework in computer science or management information systems AND 5 years of related experience. *Additional Notes:* 1. The client is allowing telecommuting for this position for the immediate future. However, candidates must reside within commuting distance from the client site as urgent on-site meetings or full-time on-site work could be required at any time. Candidates outside Atlanta willing to relocate can apply. No travel reimbursements will be made for on-site meetings. 2. Engagement extensions are possible. -- You received this message because you are subscribed to the Google Groups "Powerbuilder Assignments" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/powerbuilder-assignments/CALBV6XyRL7qpnQhU0MvMs5PfgT7ypX%2BZqyCs8uttUdsNosc0NA%40mail.gmail.com.
