Save this contract

Mind providing us with your email so we can save this contract? We promise we won't spam you, and you can unsubscribe any time.
Saved this job! You can see it in saved.
Saved this job! You can see it in saved.

Remote SQL Server 2014 contract jobs

Remote
0
USD
/hr

3 remote SQL Server 2014 contracts

Oracle PL/SQL Developer

9 days ago
$38 - $43/hourRemoteCerebra Consulting

Job Description:

Role – Oracle PL/SQL Developer (W2)

Duration – 12+ months

Location – Richmond, Virginia 23219

Local to Virginia only

Important Notes (Please Read This)

· local candidates strongly preferred

· selected candidates will be scheduled for a brief phone screen first, followed by a second interview conducted via Google Hangout

· If hired, candidates will work remotely initially but, once the quarantine is lifted, will be REQUIRED work onsite at clients 100% of the time with NO ongoing remote work.

Minimum Qualification (Please mention your number of years of experience and send it with your updated resume)

Skills

Required/Desired

Candidate's experience

Write and maintain/extend existing PL/SQL code to convert initial data sets, system enhancements, reports production, and improved transaction editing

Required 5 years

Strong development experience and/or equivalent development skills, knowledge and work history

Required 5 years

SQL Statement Tuning and Analysis

Required 5 years

Oracle 11g/ 12C PL/SQL, Toad, SQL PLUS , SQL Developer and any other Development Tools

Required 5 years

SQL Loader, Import and Export

Required 5 years

Source Code and Team Management software (TFS preferred)

Desired 5 years

SQL Server 2014 development skills

Desired 5 years

Oracle Developer Certification 11g/12c

Nice to have

Bachelor’s Degree in Computer Science or Information Systems

Nice to have

.Net Development Experience

Nice to have

Responsibilities

Design relational models for small and large scale applications
Design, code, test, debug, and document complex database programs to ensure that data processing in production systems meet user needs.
Develop and provide support to all system interfaces and coordinate with all project managers to provide specifications for all core modules.
Coordinate with various developers, project managers and analyst to prepare designs for new applications and documents all processes to ensure effective evaluation of all applications.
Analyze and ensure efficient transition of all technical design documents and develop various SQL packages to provide support to all application developers.
Monitor and recommend changes if required to all PL/ SQL packages and provide stored procedures and design and develop various relational database.
Evaluate all architecture for Oracle applications and prepare layouts for all logical models and maintain database objects for various application components.
Troubleshoot and resolve complex production issues
Design relational models for small and large scale applications
Provide data analysis and validation
Identification of performance issues on production and testing systems
PL/SQL and SQL Tuning and Optimization of newly develop and existing applications

They will work with the Teams which are working on Agile Development, Devops and TFS. We will consider, if the candidate have any working knowledge/experience in those areas.

Required Skills : Please go through the skill matrix table attached in JD

Job Type: Contract

Salary: $38.00 to $43.00 /hour

Experience:

  • Oracle PL/SQL: 6 years (Required)

Application Question:

  • This is a W2 position and any visa is fine.

Work Remotely:

  • Temporarily due to COVID-19
Get new remote SQL Server 2014 contracts sent to you every week.
Subscribed to weekly SQL Server 2014 alerts! 🎉

ETL Developer Python - DC

2 days ago
$62 - $69/hourRemoteSylger Corporation

Job Description

Sylger Corporation is an administrative and technical support contractor to the federal government. We have an immediate opening to provide support to a federal agency located in downtown DC. The candidate must be able to pass public trust security background review. This is an onsite, contract support position currently funded through September 29, 2020.

We are looking for a Python Guru with extensive system level test experience,combined with ETL data management and extensive knowledge of cloud, Data warehouse. information technology, data analysis and visualization. Knowledge of data visualization and analytical tools a plus.

Required/Desired Experience: :

  • ETL (extract, transform, load)
  • Expertise developing ETL pipelines using Python (e.g., using Pandas) in an environment that uses DevOps principles (e.g., automation, infrastructure as code, containerization, testing).
  • UNIX background and if Azure wonderful.
  • SSIS (SQL server integration service)
  • Data Warehouse Concepts
  • T-SQL DBA Concepts
  • SQL Realtime Questions

a. Additional Skills Required

  • Microsoft SQL Server 2012 and above;
  • Procedural SQL development using the T-SQL dialect;
  • SQL Server Information Services(SSIS) or similar ETL/ELT tool; and
  • Deep understanding of the relational data model and common data warehousing methodologies and architectures (e.g.,Inmon-style data warehousing, Linstedt’s Data Vault).

Knowledge/Experience Desired - Please indicate in your cover letter which one(s) you possess and level of experience (knowledgeable, intermediate or proficient)..

1. T-SQL Server Analysis Services (SSAS);

2. SQL Server Reporting Services(SSRS);

3. Python, Pandas data modeling tool;

4. Attunity or similar data warehouse automation tool;

5. Experience with database administration activities (e.g., backup/recovery, schema-level permissions, job scheduling);

6. Commercial cloud computing experience (e.g., Azure, GCP, AWS);

7. Version control or source code management systems (e.g., Git, TFS);

8. Issue/project management systems(e.g., TFS, Github, Gitlab);

b. Tasks

  • Writing transformation expressions or functions, tests to ensure edge cases are handled correctly by the transformation, and documentation to explain how and why the transformation works;
  • Proposing and designing changes to a physical data model toresolve identifiable problems;
  • Developing procedural SQL, SQL Server Information Services(SSIS) jobs, or set-based SQL scripts (i.e., using a SELECT-INTO-FROM pattern)to extract data from a source system and load it into the data warehouse ortransform and load it between logical layers within the data warehouse;
  • Monitoring deployed ETL/ELT jobs and debugging/troubleshooting any errors/issues encountered;
  • Amending ETL/ELT scripts to correctly handle exceptional aberrant records; and
  • Writing tests to verify the integrity of relations/objects within the data warehouse.

About Us

Sylger Corporation is an equal opportunity employer and does not discriminate against any applicant or employee because of race, color, religion, sex, national origin, disability, age, or military or veteran status in accordance with federal law. In addition, Sylger Corporation complies with applicable state and local laws governing non‑discrimination in employment in every jurisdiction in which it maintains facilities. Sylger Corporation also provides reasonable accommodation to qualified individuals with disabilities in accordance with applicable laws.

Job Types: Full-time, Temporary, Contract

Pay: $62.00 - $69.00 per hour

Schedule:

  • 10 Hour Shift
  • Monday to Friday

COVID-19 considerations:
During the COVID-19 government response, remote work opportunity is available. However, once government returns to normal schedule onsite presence will be required. Some telework may be allowed.

Experience:

  • Python: 3 years (Required)
  • Expertise developing ETL pipelines with Python (pandas) etc: 3 years (Preferred)
  • ETL: 5 years (Preferred)

Education:

  • Bachelor's (Preferred)

Location:

  • Washington, DC (Preferred)

License:

  • Data Vault 2.0 Certification (Preferred)
  • Python experience and/or (Preferred)

Contract Renewal:

  • Possible

Additional Compensation:

  • Bonuses

Benefits:

  • None

Employment Length:

  • 1 - 3 months

Work Remotely:

  • Temporarily due to COVID-19

Azure DevOps Engineer with Hadoop Data

6 days ago
RemoteRiya Software Consulting
  • Experience of IT service business and engineering of multi-year managed services
  • From 10-15 years plus of demonstrable enterprise level IT delivery experience
  • Cloud (5 years) in an engineering role using service and hosting solutions such as private/public cloud IaaS, PaaS and SaaS platforms. Experience in engineer technical solutions for Microsoft-centric solutions based on industry standards using Azure or other cloud providers IaaS, PaaS and SaaS capabilities. Nice to have Experience with any of the following: Azure, Azure Stack, Azure AD
  • Scripting (5 years) – having knowledge and experience with Microsoft PowerShell (required) and Linux shell scripting (preferred). Being able to understand and use best practices of completing tasks and finding solutions using existing or building new scripts to help automate today’s manual infrastructure and application tasks.
  • Functional knowledge of programming scripting and data science languages such as JavaScript, PowerShell, Python, Bash, SQL, .NET, Java, PHP, Ruby, PERL, C++, R, etc.
  • Understanding of CI/CD delivery using code management, configuration management and automation tools such as GitHub, VSTS, Ansible, DSC, Puppet, Ambari, Chef, Salt, Jenkins, Maven, etc.
  • Configuration Management (3 years) – being able to develop recipes for new solutions to deploy consistent systems, enforce configurations and settings through configuration management systems like PowerShell DSC, Chef or Puppet.
  • Tools & Environment: Hadoop Cloudera Manager, Hadoop Stack (Hive, Ranger, Atlas, Spark, NiFi, Impala), SQL Server 2012/2016, PowerBi Suite, Tableau.
  • Experience setting up a Hadoop Cluster environment, administrating including adding and removing cluster nodes, cluster capacity planning and performance tuning. Experience in running Hadoop jobs for processing multiple records of data, monitoring and sizing clusters, developing Hive queries to perform data analysis for large datasets and supporting various Solution Teams providing guidance around data quality and integrity.
  • Networking (1-3 years) - Have a solid understanding of networking capabilities, including load balancers, web application firewalls, network access control lists (NACLs), security groups, routing, tracing, DNS resolution are key to building efficient and stable solutions that prevent business downtime and provide high availability capabilities.
  • Documentation (2-3 years) - Being able to create technical documents that provide insight into the design and implementation of a solution provides teams with the ability to effectively communicate their needs and requirements across the organization. The candidate has to be able to produce clear and concise architecture and design documentation that can assist his team and other peer groups in understanding of the built solutions. The candidate must also be able to communicate complex technical issues with sensitivity to diverse audiences and people with different level of technical understanding that range from entry level support teams, management, and technical engineering resources.
  • Operational Support awareness (5 years) – A good understanding of what it takes to support the deployed applications and solutions is key to providing great service to the end users. The candidate has to be able to put themselves into a position of understanding of their consumer pain points to be able to figure out creative ways not only to find quick workarounds but also analyze the root cause of the problem and come up with ideas of resolving them in the long term.
  • Source code management (3 years) – Familiarity with source control tools such as Git, Team Foundation Server (TFVC), and SVN are a big part of automation and compliance. Understanding how these tools are and could be used is key to not only provide the proper change control management to new versions of products that are being developed, but also to help provide consistency in deploying those products/solutions throughout environments using automation.

*

Job Type: Contract

Experience:

  • Microsoft PowerShell: 5 years (Required)
  • Configuration Management: 3 years (Required)
  • Azure Cloud Engineering: 5 years (Required)
  • Hadoop Cloudera Manager, Hadoop Stack: 2 years (Required)

Work Location:

  • Fully Remote

Benefits:

  • None

Schedule:

  • Monday to Friday