*Please share resume to* *[email protected] <[email protected]>*
Hello All, Hope you are doing well, We have an urgent opportunity for *SQL DBA in Scottsdale, AZ*. So please let me know if you have any consultant for the given below position. *Make sure consultant should have all the experience required.* *Job Title: SQL DBA* *Location: Scottsdale, AZ* *Duration: 6 Month contract to hire* *Interview process: Phone then In-person* *Visa: NO H1B* *Note: Candidate needs to have experience in both SQL server 2012 or Higher and Oracle 12c or higher from a DBA capacity.Also Cloud and *NoSQL/MySQL/big data are pluses. *Preferred Qualifications * • Performance Tuning, Query Execution Plans, Stored Procedures, T-SQL, PL/SQL, Data Warehousing, and DBMS internals. • SQL Server 2012 and higher on virtualized platforms. • Oracle 12c and higher on physical or virtualized platforms. • Database architectural design and performance assessments. • Experience in high availability solutions and disaster recovery scenarios • Experience writing database server code • Possess expert knowledge of the entire Software Development Lifecycle (Waterfall and Agile) • Knowledge of Big Data is a plus • Knowledge of MDM is a plus • Capable of prioritizing and managing assignments, tasks, and significant projects to completion with minimal supervision. • Ability to create and maintain documentation of development standards in use at Republic Services. • Ability to write reports, business correspondence, and procedures manuals • Ability to interact with IT personnel on all levels to resolve issues and provide solutions in a timely manner • Capable of prioritizing and managing assignments, tasks, and significant projects to completion with minimal supervision. • Ability to create and maintain documentation of development standards in use at Republic Services. • Ability to write reports, business correspondence, and procedures manuals • Ability to interact with IT personnel on all levels to resolve issues and provide solutions in a timely manner *Principal Responsibilities * • Manages installation, patching and upgrades on all enterprise database systems. • Manages user provisioning and security on all enterprise database systems. • Maintains the integrity of data within the production environment, including the execution of proper backup and restoration policies and procedures. • Provides guidance and input on the selection and implementation of all database administration tools. • Administers database cleanup and optimization activities. • Assists with database design, particularly regarding design maintainability and scalability. • Prepares detailed technical specifications. • Provides assistance in database programming, troubleshooting and management of problems affecting IT and enterprise database applications, as well as developing the area for future expansion. • Provides escalated support and resolution of open database issues from IT Customer Support. • Manages and reviews code for deployment and promotion from development environments into QA and production systems. • Monitors performance metrics and makes enhancements or suggestions on design and infrastructure as necessary. • Plans and projects system capacity requirements for budgeting and licensing purposes. • Provides guidance, mentors staff and developers, and acts as technical escalation point for the team. • Provides database best practices and standards, performance testing and R&D. • Develops strong vendor relationships to resolve problems and coordinates the delivery of IT products and services. • Provides on-call support on a rotating schedule. • Performs other job-related duties as assigned or apparent. The statements used herein are intended to describe the general nature and level of the work being performed by an employee in this position, and are not intended to be construed as an exhaustive list of responsibilities, duties and skills required by an incumbent so classified. Furthermore, they do not establish a contract for employment and are subject to change at the discretion of the Company. *Qualifications:-* • Bachelor’s degree or higher in Computer Sciences, Information Technology, Engineering or related degree. (Required) • Minimum 5 years applicable experience in relational database systems: SQL Server (2012 or higher) and Oracle (12 c or higher). (Required) • Minimum 2 years applicable experience in MySQL. (Plus) • Minimum 2 years applicable experience in NoSQL database systems such as DynamoDB, MarkLogic, Mongo DB, Hadoop. (Plus) • Minimum 2 years applicable experience in Cloud environments such as AWS, Google, Microsoft Azure, Oracle Cloud. (Plus) • Performance Tuning, Query Execution Plans, Stored Procedures, T-SQL, PL/SQL, Data Warehousing, and DBMS internals. • SQL Server 2012 and higher on virtualized platforms. • Database architectural design and performance assessments. • Experience writing database server code • Possess expert knowledge of the entire Software Development Lifecycle (Waterfall and Agile) • Knowledge of Big Data is a plus • Knowledge of MDM is a plus • Capable of prioritizing and managing assignments, tasks, and significant projects to completion with minima l supervision. • Ability to create and maintain documentation of development standards in use at Republic Services. • Ability to write reports, business correspondence, and procedures manuals • Ability to interact with IT personnel on all levels to resolve issues and provide solutions in a timely manner • Capable of prioritizing and managing assignments, tasks, and significant projects to completion with minimal supervision. • Ability to create and maintain documentation of development standards in use at Republic Services. • Ability to write reports, business correspondence, and procedures manuals • Ability to interact with IT personnel on all levels to resolve issues and provide solutions in a timely manner *Principal Responsibilities*:- • Manages installation, patching and upgrades on all enterprise database systems. • Manages user provisioning and security on all enterprise database systems. • Maintains the integrity of data within the production environment, including the execution of proper backup and restoration policies and procedures. • Administers database cleanup and optimization activities. • Assists with database maintenance activities. • Prepares detailed technical specifications. • Aids in database programming, troubleshooting and management of problems affecting IT and enterprise database applications, as well as developing the area for future expansion. • Provides escalated support and resolution of open database issues from IT Customer Support. • Reviews code for deployment and promotion from non-production environments into production systems. • Monitors performance metrics and makes enhancements or suggestions on design and infrastructure as necessary. • Follows established processes for reporting on system capacity requirements for budg eting and licensing purposes. • Acts as technical escalation point for the team. • Writes and follows database best practices and standards, performance testing and R&D. • Provides on-call support on a rotating schedule. • Performs other job-related duties as assigned or apparent. The statements used herein are intended to describe the general nature and level of the work being performed by an employee in this position and are not intended to be construed as an exhaustive list of responsibilities, duties and skills required by an incumbent so classified. Furthermore, they do not establish a contract for employment and are subject to change at the discretion of the Company. *Qualifications*:- • *Bachelor’s degree or higher in Computer Sciences, Information Technology, Engineering or related degree. (Required)* • *Minimum 3 years applicable experience with the following: (Required)* ° - *Administration, Development and support in SQL Server (2012 or higher) (Required)* ° - Administration, Development and support in additional database systems: Oracle (12c or higher), or MySQL or other RDBMS (Required) ° - Performance Tuning, Query Execution Plans, Stored Procedures, T-SQL, PL/SQL, Data Warehousing, and DBMS internals ° - Database architectural design and performance assessments ° - Windows Server 2008 R2 or higher - Linux ksh/bash/csh experience ° - *Writing database server code, preferably T-SQL (Required)* • Minimum 1 year applicable experience in NoSQL database systems such as DynamoDB, MarkLogic, Mongo DB, Hadoop. (Plus) • Minimum 1 year applicable experience in Cloud environments such as AWS, Google, Microsoft Azure, Oracle Cloud. (Plus) Regards, *Gautam Sharma* *| **IT Technical Recruiter* (D): 408-400-3343 (O): 408-400-3356 Ext: 103 (E): [email protected] (A): 11 Bowles Ave West Boylston, MA 01583 *“**Believe you can and you’re halfway there**.**”* -- You received this message because you are subscribed to the Google Groups "CorptoCorp" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/corptocorp. To view this discussion on the web visit https://groups.google.com/d/msgid/corptocorp/CAA7CLfjtmBAg_L8gzVWipSfYsXB_Z1AnYQi9e_WRTAtcZvTOTQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
