Position :- Sr. Database Developer (Power BI, On-prem, Azure)
Location : Fort Worth-Texas (hybrid 3days)
Duration : 12 Months
Interview:- Video
Client: American Airlines
Description:
• Lead and execute the cloud migration projects from On-prem SQL Server to Azure SQL, ensuring a smooth transition with minimal downtime.
• Implement best practices for database security and compliance with data privacy regulations, incorporating access controls, encryption, and auditing mechanisms.
• Designing and developing Power BI reports and dashboards to meet the business stakeholders’ needs.
• Develop and implement custom solutions using Power Apps and Power Automate
• Power Platform (Canvas/model-driven apps, SharePoint, Power BI)
• Relational databases (design/SQL/tuning)
• Web APIs (SOAP/REST)
• Tooling (GIT/JIRA/Azure DevOps)
• Gathering and understanding business requirements for data visualization and analysis
• Collaborating with data engineers and analysts to acquire, clean, and transform data for reporting purposes
• Ensuring data security and compliance with best practices
• Troubleshooting and resolving issues in Power BI reports
• Providing training and support to end users on using Power BI
• Keeping up-to-date with the latest Power BI features and trends
• Proficiency in Power BI development, including report and dashboard creation
• Strong understanding of data modeling and data visualization concepts
• Experience with SQL for data manipulation and extraction
• Knowledge of Data Analysis Expressions (DAX) for creating calculations
• Familiarity with data warehouse concepts
• Excellent attention to detail and problem-solving skills
• Excellent communication and collaboration skills
• Ability to work independently and as a part of a team
• Adaptability to changing business requirements
• Power BI certifications are a plus
• Proactively identify and resolve performance bottlenecks, working closely with development teams to optimize query performance, indexing strategies, and resource utilization.
• Implement and maintain robust monitoring solutions to provide real-time insights into database health, ensuring proactive issue resolution.
• Conduct regular health checks, capacity planning, and upgrade/migration activities to maintain system reliability and stability.
• Perform essential database administration tasks, including installation, configuration, monitoring, tuning, backup, recovery, and troubleshooting.
• Innovate and implement automation solutions for routine tasks, reducing manual efforts and improving operational efficiency.
• Design, implement, and maintain SQL and Azure database solutions aligned with organizational requirements and industry best practices.
• Design, develop, and enhance ETL processes using Azure Data Factory or other tools to integrate data from diverse sources into the database seamlessly.
• Collaborate with teams to optimize and streamline data transformation pipelines.
• Collaborate with the teams to troubleshoot and resolve complex database issues efficiently using Azure Insights, Monitoring, DMVs, Query Store, etc.
• Demonstrate knowledge of SQL, Transact-SQL.
• Develop and maintain comprehensive documentation, standards, and procedures to foster knowledge-sharing.