sql-server database administrator

job summary: **W2 only- no C2C/ no sponsorship/no visas** **local candidates only: hybrid onsite 3 days/ week (open to Jersey City, NJ and Plano, TX locations) must be able to: Explain project details, must have comprehensive knowledge on writing complex SQL, DB Models and relationship, must have knowledge in Advance DB Concepts and analytical functions. The successful candidate will be an experienced Microsoft SQL Server 2019 database with experience of performance tuning to take advantage of new functionality offered by SQL 2019, modifying Python scripts used in the build out of the application's new React based UI.The role is part of the BUCS development team. BUCS is a critical application in the daily PNL Production process for GBAM Finance. The team of 7 is located Camberley, Singapore, and India, and Texas and the application supports 500 daily users.This role is critical to implementing new Bank wide development processes, upgrading associated toolset to latest technologies, and ensuring compliance with Bank policies and standards. Additional responsibilities include release management and day to day application support as required and mentoring and guiding more junior members of the team.Understanding of Agile and Lean software development practices and associated tools.Expert Microsoft SQL server development skills.Good OO design skills, knowledge of patterns and architectural understanding.Broad technical understanding.Appreciation of the importance of the whole project-lifecycle and business delivery.Drive changes in working practices to make delivery more efficient.Excellent written and verbal communication skills, with proven global team interaction.Willingness to learn, adopt and advance team best-practices, procedures and qualitative standards.Willingness to own issues and chase them through to completion, communicating effectively and in a timely manner, throughout.JIRAAutosysQuartzPython scripting experience.ReactC#.netInvestment banking experience, with front or middle office team experience advantageous.Knowledge of Daily PNL Production process within a Global Markets Finance function.Appreciation of Risk Awareness (Inc. Operational, Compliance, Business Reputational)   location: Jersey City, New Jersey job type: Contract salary: $58.26 - 68.26 per hour work hours: 8am to 5pm education: Bachelors   responsibilities: The role is part of the BUCS development team. BUCS is a critical application in the daily PNL Production process for GBAM Finance. The team of 7 is located Camberley, Singapore, and India, and Texas and the application supports 500 daily users. This role is critical to implementing new Bank wide development processes, upgrading associated toolset to latest technologies, and ensuring compliance with Bank policies and standards.   qualifications: Experience level: ExperiencedMinimum 10 years of experienceEducation: Bachelors  skills: SQL (6 years of experience is required)Enterprise Application Support (6 years of experience is required)python (4 years of experience is required)JIRA (6 years of experience is required)autosys (6 years of experience is required)quartz (5 years of experience is required)PNL (4 years of experience is required)C# .Net (6 years of experience is required) 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: Our client is seeking a Senior Logical Database Administrator / Database Developer for a 7 month contract opportunity in Austin, TX. Position will be remote. Program will allow candidates who are within the state (Any location within TX).   location: Austin, Texas job type: Contract salary: $80 - 90 per hour work hours: 8am to 4pm education: No Degree Required   responsibilities: - Our client's Applications division is looking for a contracting position for Senior Logical Database Administrator / Database Developer who has a proven track record in developing and maintaining high-performance enterprise software solutions using Agile methodologies. The LDBA works with cross functional teams under minimal direction with considerable latitude for the use of initiative and independent judgment. This position demands a solid background in Oracle database technologies and is central to ensuring that the applications portfolio remains available and in service of our clients. - The candidate must be available 24/7 as needed to ensure complete support for Logical database Administration and will be able to perform the below responsibilities: - Design, develop, maintain, and improve database solutions and the databases underlying the applications portfolio. - Work closely with the application development teams, business stakeholders and other partners to enhance the applications portfolio and to implement new solutions. - Building databases and applications using web platform technologies including: Java/J2EE, SOAP/REST web services, Spring, JPA, jQuery, AngularJS, IBM WebSphere, Oracle, PostGreSQL and more. - Perform advanced logical database administration / database development, performance monitoring & tuning and providing database related support to the application development teams, testing, and defect repair among other responsibilities. - Utilize Agile development practices to participate in backlog grooming & user story development - Design, develop, build & test databases to support new program & business requests and to enhance scalability & stability of the applications. - Provide application & database operations triage support to troubleshoot & resolve issues encountered in production, development, and test environments. This responsibility includes both workday and night/weekend on-call support as required to maintain high availability of the applications for various users. - Develop and modify existing Linux shell scripts to perform LDBA day to day and specific tasks and provide process documentation. - Design and develop Enterprise CI/CD workflow for DB automation using automation orchestrator such as Jenkins or similar tool set. - Advanced expertise developing and managing SQL and PL/SQL code. - Hands on experience implementing Oracle APEX tool set. - Other duties as assigned.   qualifications: Experience level: ExperiencedMinimum 8 years of experienceEducation: No Degree Required  skills: SQL ServerSQLOracle 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: Our client is looking for a Database Administrator 3 for a 7+ month contract opportunity located in Austin, TX. This role is remote but our client will only accept local candidates.   location: Austin, Texas job type: Contract salary: $50 - 58 per hour work hours: 8am to 4pm education: No Degree Required   responsibilities: Enters codes to create production data base. Selects and enters codes of utility program to monitor database performance, such as distribution of records and amount of available memory. Directs programmers and analysts to make changes to data base management system. Reviews and corrects programs. Answers user questions. Confers with coworkers to determine impact of data base changes on other systems and staff cost for making changes to data base. Modifies data base programs to increase processing performance, referred to as performance tuning. Workers typically specialize in one or more types of data base management systems. Providing assistance in the planning, development, maintenance, and monitoring of integrated database systems, and ensuring that the conceptual and design phases of new applications are consistent with the structural parameters within the database environment. Evaluates users; requests for new data elements and systems, incorporates them into the existing shared data environment, and provides technical assistance. Coordinates the use of data to ensure data integrity and control redundancy, loads databases, and reorganizes as needed. Performs data modeling and prototyping. Performs logical and physical data modeling, designs relational database models, and creates physical data models from logical data models. Performs security recovery procedures. Determines and implements database search strategies and storage requirements. Maintains data dictionary ensuring uniformity of definitions and sets standards for use of data dictionary. Monitors database performance and recommends efficiency improvements. Creates test database environment for applications section, including the creation of necessary libraries and procedures. Executes the procedures necessary to save, retrieve, and recover databases from hardware and software failures within established procedures. Assists with determining, implementing, and enhancing standards on database security and with monitoring agency disaster recovery procedures and systems. Assists with the installation of database software and with analyzing, designing, and implementing databases. Assists in benchmarking and threshold testing of databases and with establishing and controlling necessary database security. Assists in the selection of database management software. Experience in computer systems analysis or computer programming work. Knowledge of the principles, practices, and techniques of computer programming and systems design; of computer operations, systems, and procedures; of project control and cost estimating techniques; of computer programming languages; of data processing flowcharting techniques; of database structures and theories; and of current database technologies. Has working knowledge of EIR Accessibility standards and assistive technologies. Ensures that user interfaces for database administration and inputting, viewing, outputting data(via reports) are compliant with accessibility standards. Provides support to users in obtaining data / information when EIR Accessibility issues arise. Our client's project has increased demand due to Cloud Migration efforts. The increase in demand requires additional support with code releases in all environments, development, test, production, training and disaster recovery. Support is also required for improving the disaster recovery process to reduce the workload required to support Disaster Recovery. Duties include maintain grid and database software, performance tuning, ASM/storage management, and administrating user/db security. This position will support Oracle database on Oracle Exadata systems. This position will also provide additional support for MSSQL Server Enterprise for a critical application and this expertise does not exist on the team. The position is required to provide on weekends during a release and/or maintenance. The position is required to be On call. This position will also support for our client's Team including analyzing, troubleshooting, and executing data corrections production databases.   qualifications: Experience level: ExperiencedMinimum 8 years of experienceEducation: No Degree Required  skills: SQL ServerSQLOracle 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.