Sql jobs in United States

Our client is a Toronto-based leading international financial services company.They have engaged ROSS (www.getROSS.com) to help them recruit a Senior Oracle Infrastructure Database Administrator.ROSS is a team of People Specialists helping companies align their People Strategy with their business growth. We provide contingency recruitment in addition to remote or onsite HR and Recruitment solutions such as Recruitment Process Outsourcing (RPO) and Recruitment Augmentation.

Location: Montreal, Toronto or Waterloo

This role is for a Senior Oracle Infrastructure Database Administrator supporting Canadian and US requirements.

You will be a member of a team within Data Management Services (DMS) called Distributed Database Technologies. This team is responsible for establishing best practices and architecture planning on new Oracle releases, new Oracle features, and renewal delivery. We ensure that Oracle database technologies, and associated software, stays current in terms of CPU patching, hardware renewal, and infrastructure upgrades.

The role includes on-call support and off-hour implementation requirements.

Main Accountabilities:

1. Define and implement Oracle database architecture best practices;
2. Work with Database Administrators and Developers to define requirements;
3. Create or maintain clear and concise documentation for all supported database related platforms;
4. Infrastructure support of Oracle including: server/instance installs (stand-alone and clustered), service-pack upgrades, hot fixes, client tool installs, readiness programs, new feature exploitation, research and development (as needed by Infrastructure manager);
5. Support Oracle database and other database related product upgrades;
6. Performance analysis, monitoring, troubleshooting, and resolution of issues;
7. Support project development following documented standards, policies, and procedures (Change Management Process);
8. Regular review of database maintenance and performance improvement procedures;
9. Ensuring the proper setup and validation of backup and restore processes;
10. Participation in a rotational on-call schedule;
11. Occasional participation in after-hours and weekend support of production implementations, infrastructure activities, and various disaster recovery exercises;
12. Working closely with other team members, technical/team leads, management, specialized IT areas, and application support teams to ensure consistent delivery and quality of database services;
13. Define, document, and implement consistent standards and procedures;
14. Managing small to medium size infrastructure projects and participating in projects through the entire project lifecycle;
15. Database stability, availability, and recoverability;
16. Evaluation of functionality and features within Oracle and related database support products;
17. Contribute ideas for best practice improvements, process improvement, and innovative solutions;
18. Organizing and monitoring personal workload and escalating to manager when issues arise;
19. Administrative intake process support.

Qualifications:

1. Understand, can describe and can put into action, database concepts;
2. University level degree in Computer Science or related information technology degree/diploma;
3. Excellent verbal and written communication skills;
4. Passion for database administration;
5. Willingness to provide on-call support and troubleshooting;
6. Strong organizational skills with the ability to handle several tasks efficiently;
7. Ability to contribute solutions that meet or exceed business requirements;
8. Willingness to share ideas and speak up in groups.

Assets:

1. Oracle 10g or 11g certification;
2. PLSQL skills that include an understanding of system tables, stored procedures, functions, triggers, and SQL tuning;
3. Experience with Oracle installations and patching;
4. Oracle database tuning using native Oracle or other third-party tools;
5. Unix scripting;
6. Knowledge of Oracle Enterprise Manager or GRID Control;
7. Knowledge of RMAN backup and recovery strategies;
8. Knowledge of Oracle replication, mirroring, log shipping, maintenance plans, and DR recovery strategies;
9. Experience with Sybase Power Designer and Embarcadero DBArtisan;
10. Experience with Veritas clustering software;
11. Some knowledge of data-mapping and logical and physical data modeling;
12. Experience with Oracle running on various operating systems;
13. Knowledge or experience with SQL Server.

If you're not interested, but know someone who is, please help a current or former colleague in their career development by referring them. In addition, we're happy to give you a $1,000 referral fee.

Click http://www.getROSS.com/referral_fee.php for more details.