Software Developer - Oracle Apex - Pl/Sql

Qualtek Vienna , VA 22181

Posted 3 weeks ago

Job Description:

Job Summary:This position is responsible for the development, support, and maintenance of internally developed systems that support the management of workflows.

Primary Responsibilities:

  • Develop software solutions that support the Company's business needs and objectives

  • Create and develop functional requirements

  • Develop code that is modular and reusable to ensure that the system can be scaled up and interfaced with other systems

  • Integrate internal and external systems as required

  • Create and send deployment plan messages to employees of the Company

  • Run product backlog meetings for software projects

  • Accurately forecast when a requested feature will be ready for production

  • Debug and trace reported problems to determine the root cause of problems independently

  • Metrics and reporting

Other duties as assigned

Job Requirements

Qualifications

Education:

  • Bachelor of Science in Software Engineering, Computer Science, or related field required, plus 5 years' experiences in software engineering; or equivalent combination of education and experience

Technical Skills:

  • Expertise in Oracle APEX Development

  • Expertise in Oracle SQL

  • Light Oracle DBA functions

  • Expertise in at least one programming language (C/C++/C#, Java, VB/VB.net, etc.)

  • Working experience in scripting languages (JavaScript, VBScript, etc)

  • Working experience in HTML and CSS

  • Working knowledge of Microsoft SQL Server

  • Working knowledge of Microsoft Visual Studio, Microsoft Office, and Team Foundation Server

  • Experience with VBA macros is a plus

Soft Skills:

  • Highly organized and detail orientated

  • Strong interpersonal, verbal, and written communication skills

  • Ability to think analytically, apply sound judgment, and solve problems

  • Ability to multi-task and work in a fast-paced environment with minimal supervision

  • Superior time management skills; ability to meet strict deadlines

Physical Requirements:

  • Must be able to pass pre-employment screening that includes background and drug testing

  • Must have a valid driver's license and driving record that meets Company requirements

  • Must be able to sit at a desk and/or work on a computer for 6-8 hours per day

  • May be required to work long and unpredictable hours

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Sr SQL Datawarehouse Developer

Actionet, Inc.

Posted 2 months ago

VIEW JOBS 10/16/2020 12:00:00 AM 2021-01-14T00:00 ActioNet has an immediate opportunity for a Senior-Level SQL Data Warehouse Developer requiring a Secret Clearance located in Vienna, VA. ActioNet is an IT service provider and solutions integrator headquartered in Vienna, VA that works with the Federal Government and Department of Defense. Why ActioNet? It is simple. We are passionate about the inspirational missions of our customers and we entrust our employees and teams to deliver exceptional performance to enable the safety, security, health, and well-being of our nation. What's in It For You? As an ActioNeter, you get to be part of exceptional team and a corporate culture that nurtures mutual success for our customers, employees, and our communities. We give you the tools to be successful; all you need to do is bring your best ideas, your energy, and a desire to develop your skills, experience, and career. In this role, you will be responsible for designing, administering, implementing, testing, and troubleshooting activities using Kimball data warehouse methodology within a MS SQL Server environment. This position will design, build, and deploy data warehouse and analytical applications. You will utilize functional requirements to develop technical specifications and develop a solution to the specifications. The role requires a strong understanding of dimensional modeling, star schemas, data integration, data conversion, SQL, TSQL and ETL. Duties and Responsibilities: * Performs problem resolutions and root cause analysis along with recommending and implementing preventive techniques * Applies Kimball Methodology and relevant data warehouse techniques to create new database designs, root cause analysis, and optimization techniques to address client requirements * Ability to multitask in a fast-paced environment * Motivated to share knowledge in a team environment * Design new database and implement changes to existing databases. * Develop ETL processes to support internal and external client needs. * Provide and maintain technical documentation for new system processes or enhancements * Take on technical leadership responsibilities of database projects across the organization * Write complex queries in TSQL and design and develop ETL processes utilizing SSIS * Mentor junior team members as needed * Solve issues with ETL processes and SQL queries and assist in system testing new and existing ETL processes * Review ETL processes for accuracy, maintainability, and performance prior to implementation * Provide solutions for data migration and conversion * Collaborate with DBAs with respect to performance, backup strategies, security, and standard methodologies * Collaborate with internal groups and vendors to Define requirements, define test plans, and implement solutions for data migration for ETL Processes and test plans Qualifications: * 10+ years of MS SQL Server Database development * 8+ years of MS SQL Server Integration Services (SSIS) development or similar enterprise data warehousing experience * Strong understanding of MS SQL Server * Ability to write custom SQL statements * Strong understanding of dimensional modeling / star schemas * Ability to develop technical design specifications * Experience with at least one ETL tool * SQL Management Studio, SQL Server Analysis Services, SQL Server Reporting Services, and Integration Services * Expert Knowledge of reporting and query tools and practices * Expert Knowledge of conceptual, logical, and physical database design * Experience with OLAP and OLTP * Ability to modernize table structures and data management in legacy systems * Expert level knowledge with Microsoft SQL Server (2008, 2014, 2016) and technologies with SQL Server * Expert knowledge of T-SQL and developing complex database queries * Ability to lead development efforts within a team of software developers * Experience working with large databases with high number of transactions * Understands and use SQL best practices regarding security and privacy of data * Strong skills with developing SQL views, common table expressions (CTEs) and stored procedure to combine/aggregate data needed for reporting purposes * Strong skills in a performance tuning especially tuning complex queries, procedures, and indexing strategies * Experience with SQL Server Reporting Services * Experience with .NET programming languages * Experience with third party SSIS Components is a plus * Experience running SQL in a virtualized environment * Practical experience with the installation, maintenance, and upgrades of SQL Server * Practical experience with data migration and data replication tools, technologies, and strategies * Experience with designing and developing SQL clusters and data warehouses a plus. * DOD 8570 IAT Level 2 certification * Bachelor's Degree in Computer Science or similar field * Active/Current Secret Clearance Are you ready to make a difference? ActioNet is an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status. Actionet, Inc. Vienna VA

Software Developer - Oracle Apex - Pl/Sql

Qualtek