Are you looking for a New Job or Looking for better opportunities?
We got a New Job Opening for
Full Details :
Company Name : Prexel LLC
Location : Salt Lake City, UT 84116
Position : Database Administrator
Job Description : Client: State of Utah – Utah Department of Human Services (DHS)Job Title: Database Administrator (99506)Location: 195 N 1950 W, Salt Lake City, UT 84116Duration: 33+ Months (Almost 3 years)Job Details: Database ArchitectureDBAs should focus on architecture, administration and dbPaaSDBAs need to understand the following: SLAs and their implicationsSolid knowledge of cloud architecture.The cloud provider’s scheduled maintenance and its implications on the businessThe consistency models that cloud providers offer with different dbPaaS servicesNoSQL databases, their architecture and the ways in which they differ from relational database management systems (RDBMSs)The different NoSQL database types, such as key-value stores, graph stores, document databases and wide-column storesScale-out database implementationsBig data applicationsCost OptimizationDBAs should understand the costs of running databases in the cloud and the methods to optimize cost, including: Instance classPrimary and backup storageI/O requests per monthData transferGrowth expectationData ManagementIncludes functions such as: Data life cycle managementRetentionData warehousingReportingDisaster Recovery (DR) and ReplicationLeverage, and replicate data to, different zones and regions as needed. DBA would participate in planning with DevOps, as needed.Performance MonitoringIt is very important to monitor and continuously optimize a cloud database deployment.Bad performance may lead to increased resource provisioning, which, in turn, may lead to higher costs. Hence, staying on top of best-of-breed technologies and provider innovations helps DBAs continuously optimize the environment.Security ManagementAlthough cloud providers secure their platform services, DBAs still must:Ensure data protection at rest, in transit, in memory and during backupMonitor database access for unauthorized accessKnowledge, Skills, and Abilities: Understanding of database architectureExtensive experience with: PostgreSQL – This is the primary needMySQLSQLReplication methodsSecurity modelOptimization methodsFamiliarity with: RDS/AuroraJPA/HibernateOracleMSSQLETL/DW processes and design patternsUnderstanding and experience with: Data deduplicationQuery optimizationCoordinating work efforts with DevSecOps and other DBAsAssisting with data analysts with queriesJob Types: Full-time, ContractPay: $75.00 – $85.00 per hourSchedule:8 hour shiftAbility to commute/relocate:Salt Lake City, UT 84116: Reliably commute or planning to relocate before starting work (Preferred)Education:Bachelor’s (Preferred)Experience:MySQL: 1 year (Preferred)Database administration: 1 year (Preferred)Oracle: 1 year (Preferred)PostgreSQL: 1 year (Preferred)Work Location: One location
This post is listed Under Utah jobs
Disclaimer : Localpublic.in works to publish latest job info only and is no where responsible for any errors. Users must Research on their own before joining any company