Ref No.: 18-32315
Location: Boston, Massachusetts
Position Type:Contract
Experience Level: 6 Years
Start Date: 05/30/2018
 Role: Oracle DBA
Location: Boston MA
Duration: Long term Contract
Job Summary: 
The Database Administrator designs, manages, maintains and improves complex database systems and platforms throughout the entire database lifecycle.  This role will view performance and efficiency as critical factors in the data services provided.  Using their technical expertise, the Database Administrator will provide database solutions to the IT organization while maintaining a view on how these solutions will impact the enterprise.  Judgements and recommendations will be made based on analysis and knowledge of the existing environment and available features provided by the database management systems.
Essential Duties and Responsibilities: 
  • Ensures availability, security, integrity, and performance of assigned databases.
  • Recommends and implements data models and database designs that support efficient data access.
  • Exercises critical thinking and problem-solving when resolving database performance, capacity, replication, and other data issues. 
  • Installs and configures database management software and applicable options, packs and patches while adhering to Client standards.
  • Collaborates with developers and programmers to understand the potential architectural impacts of different database strategies and coding practices.
  • Develops and implements database deliverables, such as conceptual designs, logical designs, capacity planning, external data interface specifications, data loading plans, data maintenance plans, and security policies.
  • Builds IT solutions to ensure they meet the business needs while maintaining a focus on enterprise goals and integration strategies.
  • Partners with Business Teams to assess how technologies can best streamline processes and/or add business value.
  • Keeps current with key technology, business and industry trends.
  • Participates in disaster recovery and business continuity planning.
  • Develops innovative approaches to solving problems.
  • Follows both industry and Raymond James best practices and standards in all database areas.
  • Automates repetitive and/or error-prone tasks.
  • Schedules and manages jobs for data transfers and sundry procedures and monitors performance and impact on operations.
  • Analyzes long-term database performance trends to optimize database and application performance.
  • Configures, supports, and optimizes replication.
  • Performs other duties and responsibilities as assigned.
Experience and Skills:
  • Minimum of a B.S. in Computer Science, MIS or related degree and three (3) years of relevant experience including relational database theory and relational database programming experience or combination of education, training and experience.
  • Experience in Financial Services or other regulated industry preferred.
  • Experience with the following Oracle products and options
  • Oracle RDBMS Enterprise Edition
  • Real Application Clusters (RAC)
  • Replication solutions such as Data Guard and Golden Gate
  • Exadata and other engineered systems
  • Multitenant
  • Oracle Enterprise Manager (OEM)
  • Experience with PL/SQL code development and tuning
  • Performance tuning and analysis using AWR, ASH.
  • Scripting and automation using shell scripting, Perl, Python, etc.
  • Exposure to ITIL principles a plus.
  • Capacity planning for all aspects of a database system (storage, compute, memory, etc.)
  • Understanding of networking and connectivity and how it relates to a database environment.
  • Informed position on cloud services and options