Amick Brown is seeking an experienced Database Engineer  for our direct client.
Location: Santa Clara, CA
Duration: 11 Months
Estimated pay range: $ 71.11 - $ 88.89 an hour per client contract and candidate skills, experience and work location.

Job Description

• Designs, builds, and oversees the deployment and operation of technology architecture, solutions, and software to capture, manage, store and utilize structured and unstructured data from internal and external sources.
• Establishes and builds processes and structures based on business and technical requirements to channel data from multiple inputs, route appropriately and store using any combination of distributed (cloud) structures, local databases, and other applicable storage forms as required.
• Creates and establishes design standards and assurance processes for software, systems, and applications development to ensure compatibility and operability of data connections, flows and storage requirements.
• Reviews internal and external business and product requirements for data operations and activity and suggests changes and upgrades to systems and storage to accommodate ongoing needs.
• Managing a mix of both physical and cloud-based database servers, the Database Administrator is responsible for the care, feeding, and uptime of mission-critical infrastructure.

Responsibilities:

• Responsible for implementing, managing, and tuning high-availability on Aurora PostgreSQL, Mongo, and other databases in AWS Cloud, Atlas and OnPrem.
• Establish policies and procedures pertaining to data management, security, maintenance, and utilization.
• Develop, manage, and test database backup & recovery strategies, verifying data integrity.
• Perform database installations, configurations, upgrades, and migrations.
• Proactively monitor and tune for system performance.
• Responsible for capacity planning and recommending paths to account for application growth that are in line with industry best practices.
• Consult with development and architecture teams to help meet continued application growth.
• Define and implement database schema and configurations working with our development teams.
• Create and maintain documentation of procedures, schemas, and guides for troubleshooting database systems.
• Perform review of schema, stored procedures, and other changes to the database DDL.
• Audit for data integrity and consistency across systems.

Required Skills:

• M.S. in Computer Science, Software/Computer Engineering, Information Technology, Electronics, Data Management or Applied Math with minimum of 5 years industry experience or B.S. degree with minimum (8) years industry experience
• 6+ years of experience working as a Database Administrator
• In-depth understanding of relational and dimensional database models and concepts.
• Strong experience with relational SQL ( Microsoft SQLServer, Aurora Postgres.), NoSQL ( MongoDB, Elasticsearch etc.), Splunk, Snowflake and AWS RDS administration,
• Significant practical hands-on experience with database administration, backup and recovery, database replication, hot stand-by, clustering, and table partitioning, performance tuning and high-availability solutions
• Detailed understanding of Postgres database server architecture, concepts, features, and high-availability technologies.
• Expert knowledge of PL/PgSQL, triggers, and stored procedure development and optimization in PostgreSQL
• Previous experience with Aurora PostgreSQL, Snowflake is a plus.
• Working knowledge of Terraform, Chef, Ansible, or Puppet is plus.
• Working knowledge of Docker and previous production experience with PostgreSQL or other databases in a Docker environment a plus.
• Understanding of security - SAML, OAUTH, Kerberos, JWT Token, SSO
• Experience working with Windows and Linux OS with system resource monitoring and tuning.
• Ability to handle stressful problems and solve complex problems under pressure
• Ability to communicate effectively with others, both in oral and written communication
• Excellent planning, problem solving, organization and project management skills

Amick Brown is an Information Technology consulting company specializing in ERP, Data Analytics, Information Security, Application Development, Networking, and Cloud Computing. The company was founded in 2010 and is headquartered in San Ramon, California.

Regular full-time employees are eligible for the following Amick Brown provided benefits:
 

• Health
• Vision
• Dental
• 401k with company match
• Paid time off.
• Sick Leave
• Long -Term Disability
• Life Insurance
• Wellness & Discount Programs