Remote Internship Oracle Pl Sql Developer Jobs (NOW HIRING)

Job Summary:
TPI Global Solutions is seeking a Senior SQL and Power BI Developer to lead complex IT applications design and development. The role involves creating Power BI dashboards, optimizing database solutions, and ensuring the quality of applications software while collaborating with stakeholders.
Responsibilities:
• The Senior Programmer will possess knowledge and experience in applications software development principles and methods sufficient to participate in the design, development, testing and implementation of new or modified applications software; operating systems installation and configuration procedures; organization’s operational environment; software design principles, methods and approaches; principles, methods and procedures for designing, developing, optimizing and integrating new and/or reusable systems components; pertinent government regulations; infrastructure requirements, such as bandwidth and server sizing; database management principles and methodologies, including data structures, data modeling, data warehousing and transaction processing; functionality and operability of the current operating environment; systems engineering concepts and factors such as structured design, supportability, survivability, reliability, scalability and maintainability; optimization concepts and methods; establish and maintain cooperative working relationships with those contacted in the course of the work; and speak and write effectively and prepare effective reports.
• Possess advanced knowledge of SQL, encompassing intricate query optimization techniques, nuanced data manipulation strategies, and a keen ability for fine-tuning database performance.
• Proficiency extends to crafting queries that operate efficiently even with large datasets, ensuring optimal processing times and minimal resource usage.
• Demonstrate expertise in working with diverse and popular database management systems such as Oracle, MySQL, SQL Server, and Azure SQL. Proficiency includes database administration, schema design, and the seamless execution of operations across various platforms, showcasing adaptability and proficiency in different environments.
• Exhibit a strong understanding and extensive experience in Oracle PL/SQL programming.
• This expertise encompasses the development and optimization of intricate stored procedures, triggers, and functions. Proficiency in PL/SQL ensures the seamless execution of complex tasks, enhancing database functionality and performance.
• Showcase the ability to design efficient data models that facilitate optimal storage and retrieval of information. Proficiency in creating robust data structures ensures streamlined access to relevant data, enhancing overall database efficiency and reducing query complexity.
• Demonstrate a comprehensive understanding of Extract, Transform, Load (ETL) processes and tools and scripting languages like Python, Perl, or Shell scripting for automating and data manipulation.
• Exhibit a strong ability to optimize both database queries and underlying structures.
• Proficiency in query optimization techniques and structural refinements enhances database performance and responsiveness.
• Skills in identifying and rectifying bottlenecks contribute to streamlined operations.
• Possess knowledge of data warehousing concepts and tools, enabling effective management of vast volumes of data. Expertise in data warehousing ensures efficient storage, retrieval, and analysis of large datasets, supporting the organization's data-driven decision-making processes.
• Display proficiency with Power BI, including crafting insightful visualizations and reports that translate raw data into valuable, actionable insights.
• Demonstrate proficiency in utilizing version control systems like Git to effectively manage and track changes in database scripts and queries.
• Expertise in version control ensures systematic tracking of modifications, enabling collaboration, maintaining code integrity, and facilitating seamless integration of changes into the database systems.
Qualifications:
Required:
• Minimum of seven (7) years of experience in electronic data processing systems study, design, and programming.
• At least four (4) years of that experience must have been in a lead capacity.
• 4 years of experience in the past 7 years writing complex SQL queries, optimizing database performance, and ensuring data integrity across various database management systems, including Oracle, MySQL, SQL Server, and Azure SQL.
• 3 years of experience in the past 4 years working with advanced skills in Oracle PL/SQL or similar procedural languages, adept at developing efficient stored procedures, triggers, and functions for seamless database operations.
• 3 years of experience in the past 4 years working with designing and optimizing database schemas, ensuring scalability, data normalization, and efficient indexing for high-performance transactional systems.
• 3 years of experience in the past 4 years working with developing intricate reports and visualizations using tools such as Cognos, Power BI, or Crystal Reports, transforming raw data into meaningful insights for diverse stakeholders.
• 3 years of experience in the past 4 years working with Implementing robust ETL processes, integrating data from diverse sources into data warehouses flawlessly, ensuring accuracy, consistency, and reliability of data for analytical purposes.
• 3 years of experience in the past 4 years working with Providing technical leadership to junior developers, conduct thorough code reviews, offer mentorship, and foster a collaborative environment within the team.
• 2 years of experience in the past 4 years working with communicating complex technical concepts clearly to both technical and non-technical stakeholders, ensuring a shared understanding of database solutions and their alignment with business objectives.
• 3 years of experience in the past 4 years working with complex database issues, debugging code, and optimizing queries for peak performance.
• 2 years of experience building Power BI reports.
• 2 years of experience in the past 4 years maintaining comprehensive documentation of database schemas, stored procedures, and ETL processes, ensuring knowledge accessibility and smooth transfer within the team.
• Possession of a bachelor’s degree in an IT-related or Engineering field.
• Bachelors in computer science, data analytics, or a related field.
Company:
TPI Global started in 1998, providing technical professionals to businesses scrambling to fix the Y2K bug. Founded in 1998, the company is headquartered in Atlanta, USA, with a team of 201-500 employees. The company is currently Growth Stage.