Database Administrator Advisor

Company: Avacend, Inc.
Location: Round Rock
Posted on: June 21, 2022

Job Description:

Pay Rate: $58 on W2Job Title: Database Administrator AdvisorLocation: Round, rock, TxDuration: 9 months Who provides the know-how to protect data, tools and information systems at Technologies?It's the Database Admin team within our Information Technology organization. We develop, design and optimize our information technology and systems functions that support our business processes and technical information systems platforms. Focused on efficiency, performance, availability and platform compatibility, we analyze, select and modify enterprise systems and application software, install network hardware and software and manage our databases - setting system and programming standards along the way.What you'll achieve:As a Database Administrator Advisor, you will be responsible for the maintenance and providing technical consultations and Database Solutions, Database Platform Reliability Services which includes DB Provision and Support. You will work with Application Team, Development Team, and DB EngineeringYou will:---Install, configure, upgrade, and manage the database Servers---Configure and manage database maintenance, including backups, performance tuning, and any additional required maintenance---Apply database-related patches---Manage database clusters as well as environments containing Replication Services---Performs as a technical subject matter expert in the development of highly complex, innovative and cost-effective database solutions---Designing and handling Disaster recovery/high availability.---Support day-to-day incidents and change process .Essential Requirements---Solid experience in MemSQL/SingleStore, MySQL, PostgreSQL, Mongo Database Administration in a Big Enterprise organization---At least 5 to 8+ or more years working as a DBA and handling production critical databases/Servers---Should be very strong in replication concepts and troubleshooting replication issues within SLA---Good communication, time management, negotiation and leadership skills---Masters or Bachelor's degree in any disciplineDesirable Requirements---Experience in scripting tools: PowerShell, Perl, Python, Shell, etc---Experience in Oracle and any other No SQL DB technologies like Mongo or Elastic Search or Cassandra would be an added advantage---Database Certification would be an added advantageACCOUNTABILITIES Provides database operations support, monitoring databases and backups, resolving repetitive and simple events and escalating more complex incident according to the standard operating procedures Provides production database support with specific focus on availability, capacity, performance, security and recoverability. Performs database installation and configuration, tuning, capacity planning, health checks, backups & recovery and change management according to documented standards Troubleshoots issues with database instances, DR, replication and backups and eliminates root causes thru systematic problem management practices Provides database development/project support in compliance with database design standards. Designs and develops database systems to meet application and business requirements across multiple platforms and computing environments. Provides guidance on best practices and standards and supports the project teams with database related activities throughout the software development lifecycle Evaluates and certifies database technologies, while assisting in the management of vendor relationships and the definition of vendor product feature sets. Designs, develops and drives global implementation of database standards, tools and procedures throughout the IT organization Ensures database security controls meet internal and external audit and compliance requirements. Implements database technologies for global standards, data classification, and data privacy according to regulatory guidelines RESPONSIBILITIES Designs, plans, and implements most aspects of database management and may begin to specialize in one aspect of database management such as data administration, web connectivity, physical structure, logical design, SQL and SQL applications or overall architecture and database analysis Participates on new initiatives/projects of moderate complexity Evaluates and recommends the purchase and utilization of software products to assist in the management of data Plans and performs installation and maintenance of DBMS software Diagnoses problems and determines resolution for applications and system software Measures DMBS performance and modifies system level configuration to optimize performance Anticipates business constraints and their applicability to database management May be responsible for planning and upgrading of major/complex application and database upgrades Develops, upgrades and maintains medium to large size database systems Performs security management by auditing and maintaining roles, privileges and user profiles Performs complex application builds and refreshes; installs, upgrades, patches and maintains application environments Supports planning and execution of new application capabilities and major upgrades; supports creation of disaster recovery procedures Consistently provides guidance and project direction to less experienced team members

Keywords: Avacend, Inc., Round Rock , Database Administrator Advisor, IT / Software / Systems , Round Rock, Texas