sql-server database administrator

job summary: Client is seeking an Oracle database developer/engineer to serve as QA Analyst to validate complex queries developed in Hadoop and ETL validation of data moved between different databases. This position will be QA Testing data being integrated into and out of different databases. Roles and Responsibilities - Responsible for the design, development, testing and support of technical tasks in Oracle Cloud - Technical Tasks include Complex Query Validations, BI Publisher Reports/Integrations, Fast Formulas and HCM Extracts - Prepare and deliver technical workshops and engaging with business Stakeholders in requirements gathering and business mapping - Carry out functional testing on code and develop test plans to verify logic of new or modified code. - Create appropriate documentation such as technical documentation or user guides for Database - Supporting existing customers technical solutions and resolving any issues/enhancements that may occur. - Adherence to documented development standards and implementation of "best practice" development methods   location: Newark, Delaware job type: Contract salary: $55 - 65 per hour work hours: 8am to 4pm education: Bachelors   responsibilities: Client notes: This role will be testing Complex SQL Queries. The Key skill set is a strong background with SQL scripting. The Oracle HCM skills listed are a nice to have - the true required Skill set is an expert level SQL scripting specialist. This is NOT a developer position. The role is testing, validating and remediating Complex SQL Queries. Job Description: Note: Client is seeking an Oracle database developer/engineer to serve as QA Analyst to validate complex queries developed in Hadoop and ETL validation of data moved between different databases. This position will be QA Testing data being integrated into and out of different databases. Roles and Responsibilities - Responsible for the design, development, testing and support of technical tasks in Oracle Cloud - Technical Tasks include Complex Query Validations, BI Publisher Reports/Integrations, Fast Formulas and HCM Extracts - Prepare and deliver technical workshops and engaging with business Stakeholders in requirements gathering and business mapping - Carry out functional testing on code and develop test plans to verify logic of new or modified code. - Create appropriate documentation such as technical documentation or user guides for Database - Supporting existing customers technical solutions and resolving any issues/enhancements that may occur. - Adherence to documented development standards and implementation of "best practice" development methods Mandatory skills and experience required - At least 5 years of experience in Oracle HCM project implementations as a technical developer - Extensive Knowledge on underlying database structure for HCM Oracle Cloud (Fusion) or EBS - Excellent Oracle technical skills with the ability to build complex Oracle components using PL/SQL and SQL - Extensively worked on BI Publisher reports, Migration and Workflow components - Excellent Communication skills (written and oral) with good attention to detail - strong leadership skills and a dedication to achieving business outcomes and project deadlines. - Ability to quickly grasp new concepts, incorporate innovations, and stay up to date with industry and business directions. - Proven experience in a customer facing role - Experience working with an onshore/offshore delivery model - Team player with demonstrable ownership of issues and ability to escalate when necessary - Ability to operate successfully in a multi-tasked environment, with periods of pressure - Flexibility when it comes to supporting new technologies - Exposure to Hadoop is very important - Experience working with Teradata   qualifications: Experience level: Education: Bachelors  skills: OracleManual QA Testing Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com. Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility). This posting is open for thirty (30) days.

job summary: Job Summary: This position is responsible for implementing and maintaining complex database systems. Additionally, is this role will work cross functionally with key IT professionals to ensure that database systems meet performance, security, and reliability requirements. Lastly this role will be responsible for developing and implementing disaster recovery and business continuity plans. ESSENTIAL JOB FUNCTIONS AND RESPONSIBILITIES Designs, implements, and maintains complex database systems using database management systems (DBMS) such as Oracle, SQL Server, or MySQL Develops and implements data backup and disaster recovery plans to ensure data availability and business continuity. Works with integral members within the IT department to ensure database systems meet performance and reliability requirements. Identifies and resolves database performance and scalability issues. Develops and implements database security policies and procedures to protect sensitive data. Evaluates new database technologies and make recommendations for adoption. Trains and mentors junior database engineers May lead projects and perform other duties as assigned. Occasional business travel may be required. KNOWLEDGE, SKILLS AND ABILITIES Knowledge of data warehousing and ETL processes Able to one or more mapping/ETL tools (e.g., RedPoint Data Management, Alteryx, Data Stage, Dataflux, Informatica, SSIS, Sterling B2B Integrator). Experience with one or more traditional development languages (e.g., python, java, C#, C++). Experience processing data including validation techniques, processing efficiencies, file processing (hierarchical, flat, delimited, etc.), and retrieving or populating data within a Database Management System (DBMS). Solid understanding of relational database concepts, data quality, metadata management, and performance tuning. Adept at designing and implementing large scale data integrations. strong experience using an enterprise data management tool or custom software development in that subject area. strong analytical and problem-solving skills Excellent communication skills, both verbal and written Excellent ability to take manage customers' needs and to make critical decisions while following company procedures. Proficient in the use of Microsoft Office tools: Word, Excel, Outlook, and PowerPoint E Driven ability to complete assigned tasks under stressful situations. EDUCATION AND TRAINING Bachelor's Degree in Computer Science or a related field preferred. Master's Degree desired. Five (5) plus years of experience in database engineering or a related field. Demonstated experience with database security and disaster recovery planning. Demonstrated experience with cloud-based database systems such as AWS RDS or Azure SQL Database. Demonstrated experience with NoSQL databases such as MongoDB or Cassandra. Certification in a relevant DBMS or related technology. Or equivalent combination of education and/or experience. Other Competencies Drive for Results - Establishes aggressive goals and takes appropriate, calculated risks to achieve results. Acts with a sense of urgency regarding personal and organizational goals and priorities. Demonstrates discipline and does the right thing, even when it is difficult. Shows determination and persistence in the face of challenges.Customer-Focus - Listens to understand the customer's perspective and is patient with their frustrations and struggles. Anticipates customer needs and demonstrates commitment to exceeding their expectations. Shares ideas on how to enhance the customer experience. Builds rapport with customers through being empathetic and demonstrating reliability.Self-Awareness - Thinks through possible outcomes and impact on others before taking action. Recognizes strong emotional reactions and directs the energy into productive behavior and communication. Can articulate personal values and aspirations. Leverages personal strengths while working on managing weaknesses.Valuing Others - Values and embraces the individuality of others by treating everyone with dignity, respect, and compassion. Appreciates other cultures and perspectives and seeks common ground through listening and demonstrating empathy. Credits others for their contributions and accomplishments. Builds relationships across the organization through transparency and extending trust to others.Learning Agility and Development - Seeks after and takes on challenging assignments to broaden skills and perspective. Proactively seeks out resources to support personal development (books, articles, online resources, company resources, subject matter experts, etc.) Reflects on and discusses successes and failures to learn and strive for continuous improvement. Continuously seeks feedback from peers and leaders on growth opportunities.Innovation - Seeks and shares ideas to improve work processes, from small tweaks to large changes. Applies the creative ideas from others and embraces opportunities to pilot and experiment. Reflects on and discusses how new ideas and processes impact other teams and the customer. Adjusts to changing conditions and finds ways to get the work done   location: Denver, Colorado job type: Contract salary: $60 - 75 per hour work hours: 8am to 5pm education: Bachelors   responsibilities: Designs, implements, and maintains complex database systems using database management systems (DBMS) such as Oracle, SQL Server, or MySQL Develops and implements data backup and disaster recovery plans to ensure data availability and business continuity. Works with integral members within the IT department to ensure database systems meet performance and reliability requirements. Identifies and resolves database performance and scalability issues. Develops and implements database security policies and procedures to protect sensitive data. Evaluates new database technologies and make recommendations for adoption. Trains and mentors junior database engineers May lead projects and perform other duties as assigned. Occasional business travel may be required.   qualifications: Experience level: ExperiencedMinimum 6 years of experienceEducation: Bachelors (required)  skills: SQLProfessional EngineerProfessional EngineerProfessional Engineer Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com. Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility). This posting is open for thirty (30) days. It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

job summary: Position Summary: Senior Oracle PL / SQL Software Engineer with technical proficiency and demonstrated experience on database development, data modelling and application management for a business facing web application. Senior database developer will write, review and design complex SQL queries. The person will also design Oracle tables and schemas, review developer's designs, suggest to development team on using Oracle database features, and liaison with DBAs. Primary Skill: Oracle SQL / PLSQL Required Skills: Application Developer proficient on Oracle PL / SQL, database design, data modeling, performance tuning, stored procedures, backup and recovery, data security management, and version controlEssentially, a deep understanding of database concepts and the ability to efficiently manipulate data using SQL to create and maintain robust database systems Required Skills: Oracle 19 gStrong SQL skills.Experience in data modeling and database design.Optimize SQL queries, views, functions and stored procedures.Materialized viewsPerformance tuningERD diagramsClear communication skills.Able to work with cross application teams on multiple initiatives and provide technical leadership on code quality, design & implementation. Desired Skills: Familiarity and understanding of Java/J2EE,Knowledge of Java integration with Oracle DBOracle application DBA skills   location: Charlotte, North Carolina job type: Contract salary: $55.06 - 65.06 per hour work hours: 8am to 5pm education: Bachelors   responsibilities: Application Developer proficient on Oracle PL / SQL, database design, data modeling, performance tuning, stored procedures, backup and recovery, data security management, and version control   qualifications: Experience level: ExperiencedEducation: Bachelors  skills: Oracle ApplicationsSQL Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com. Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility). This posting is open for thirty (30) days.