Database Administrator - Senior

at  Arthur Grand Technologies Inc

Arthur Grand Technologies is currently seeking a highly motivated of Database Administrator - Senior one of our client.
Position : Database Administrator - Senior

PUBLIC SECTOR EXPERIENCE

· 5+ years of experience working with federal/provincial/broader public-sector healthcare providers
· Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices
· Ability to produce technical documentation that comply with industry standard practices
· Knowledge and experience with Public Sector Health related projects
· Knowledge and understanding of Ministry policy and IT project approval processes and requirements would be an asset

· Experience adopting and adhering to Public Sector Unified I&IT Project Methodology, Public Sector Enterprise Architecture and Public Sector Gating process, and Public Sector Standard Systems Development Methodologies

• Experience with large complex IT Health-related projects.”

TECHNICAL SKILLS

• 10+ years of experience in the following:
  · Database administration using Oracle technologies and products, including Oracle 19C, Oracle RAC, RMAN backup/recovery, Data Compression and encryption, Oracle Data Guard, Oracle GoldenGate and Oracle EM
  · Experience in complex BI/DW solution design, implementation, maintenance, and support, using Oracle 19C, Oracle Directory Server, Informatica PowerCenter & Data Quality, IBM Cognos, Business Objects in a Sun Solaris/RedHat environment

· Superior technical expertise in: enterprise data warehouse database configuration, optimization and tuning, support and maintenance with Oracle database in a Sun Solaris environment for complex Business Intelligence/Data Warehouse (BI/DW) solutions, Bi-Directional Data Replication for Active-Active Solution Crossing Data Centers, and multi-tier web-based off-the-shelf solutions tools, including Oracle technologies & products (Oracle Database, Active Data Guard, GoldenGate, etc.) Cognos, Informatica PowerCenter, Power exchange & Data Quality

• Experience with Cognos, BO, Informatica and LDAP servers

​CORE SKILLS AND EXPERIENCE

• 10+ years experience in the following:
  · Administering and supporting and troubleshooting server/system issues related to Cognos, BO, Informatica, LDAP and Oracle DBs
  · Experience with physical database designs, operation and administration of database management system (DBMS), including database optimization, performance tuning, backup and recovery, partitioning, compression, and security
  · Developing and maintaining data design models, database schemas and scripts, technical documentation and specifications
  · Providing build books/deployment guides for the deployment to higher environments
  · Experience with database setup, migration, tuning capacity planning, and data conversion in a large operation with multiple environments
  · Maintaining data design models, database schemas and scripts, technical documentation and specifications
  · Providing specialized technical expertise in database administration, data warehouse design, data modeling, Extraction, Transformation & Load (ETL), information management, BI solution design, development and maintenance
  · Monitoring and enforcing database rules
  · Providing Database (Oracle technologies & products) expertise for troubleshooting, problem resolution and performance tuning of the production solutions in operation
  · Providing professional opinions and recommendations for technical issues, management, briefings, etc., and provide expertise, offer solutions and lead implementation of approved recommendations
  · Coordinating with Oracle support, Informatica support and Cognos support in opening tickets and providing information to find solutions and root cause analysis of ongoing issues
  · Producing project plans for database management activities
  · Experience with middleware, gateways and reporting systems

· Experience in Incident, Change and Configuration Management procedures

• Experience with use of information retrieval packages and proficiency with query languages.”

​GENERAL SKILLS

· Proven technical leadership skills with ability to identify areas for improvement, and recommend solutions
· Exceptional analytical, problem solving and decision-making skills
· Demonstrated strong interpersonal, verbal and written communication, and presentation skills
· Proven troubleshooting and critical thinking experience
· Demonstrated ability to apply strong listening skills to facilitate issue resolution
· Effective consulting skills to engage with all stakeholders with proven track record for building strong working relationships
· Strong interpersonal, facilitation and negotiation skills with ability to build rapport with stakeholders and drive negotiations to a successful outcome

· Excellent customer service skills, including tact and diplomacy to ensure client needs are managed effectively

• A motivated, flexible, detail-oriented and creative team player with perseverance, excellent organization and multi-tasking abilities, and a proven track record for meeting strict deadlines.

Please refer the Job description for details