Cloud Operations DBA II

Company: PowerSchool
Location: Roanoke
Posted on: June 24, 2022

Job Description:

Location: US-VA-Roanoke - USCategory: DevelopmentType: Full TimeID: 2022-4823OverviewThis position, under the general direction of the Manager and Director, will be responsible for the overall management and maintenance of information databases used to operate PowerSchool products and customer facing systems within an agile environment. The DBA partners with application development teams and infrastructure operations to ensure that database performance is not hindered and performance standards adhere to service-level agreements set with the enterprise.ResponsibilitiesEssential duties and responsibilities include the following. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Lead creation of overall strategy for enterprise level database policies, SOP, and BC plans
• Execute ticket triage, investigation and resolution of reported incidents
• Responsible for execution of day-to-day tasks related to monitoring and managing moderately complex database systems and infrastructure to ensure service availability and data security
• Monitor and configure systems resources (memory, disks space & CPU utilization)
• Manage and perform database server software patches and updates
• Improve customer experience with performance tuning and database optimization
• Create, document and train partners on database administration SOPs
• Participate in 24x7 on-call rotations to resolve incidents in support of production systems
• Performs root cause analysis on trended database incidents and major outages up through the application stack
• Develops automation that can trigger off a variety of industry standard tools to resolve common issues in the environment or maintain operating levels
• Work closely with application architects and developers throughout product development SDLC to implement best practices, proper types of file organization, indexing methods, security measures and others
• Lead the design of a scalable management of an enterprise database environment including high availability deployment, pluggable databases, encryption and more
• Lead the creation and the implementation of BC plans, including but not limited to, backup, restore and data retention policies and procedures
• Lead database capacity planning and budgetary exercises
• Mentor other DBAs on staff QualificationsTo be considered for and to perform this job successfully, an individual must be able to perform each essential duty and responsibility satisfactorily. The requirements listed below are representative of the knowledge, skill and/or ability required. Qualifications include:
  • 4+ years' experience as MS SQL DBA
  • 2-4+ years' experience as PostgreSQL, MongoDB, mySQL administrator
  • Bachelor's degree in Computer Science, Information Systems, or equivalent degree
  • Strong working knowledge of RDBMS
  • Strong working knowledge of Shell Scripting, Batch Scripting, or Perl Scripting
  • Strong working knowledge with Windows
  • Strong working knowledge on N tier, multi and single tenant applications
  • Strong working knowledge with Logical Modeling, Physical Modeling, Relational Modeling, ER Diagrams, Entities, Attributes, Cardinality SQL Stored procedures, Functions, Views and triggers
  • Strong working knowledge with the functionality of business continuity, disaster recovery, Virtualization, and CRM products
  • Strong working knowledge with database replication and high availability
  • Strong working knowledge with compute infrastructure changes such as upgrading RAM, creating, mounting and resizing disk drives, etc.
  • Strong working knowledge with data warehouses and Extract, Transform, Load (ETL)
  • Strong working knowledge with Cloud providers and their associated database services, such as AWS, AWS RDS, Azure, Rackspace, a plus
  • Experience with Site Reliability Engineering a plus
  • Experience with Continuous Integration/Continuous Delivery a plus
  • Experience with web analytic technologies a plus
  • Strong problem-solving ability
  • Strong written and verbal communication skills EEO CommitmentPowerSchool is committed to a diverse and inclusive workplace. PowerSchool is an equal opportunity employer and does not discriminate on the basis of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status. Our inclusive culture empowers PowerSchoolers to deliver the best results for our customers. We not only celebrate the diversity of our workforce, we celebrate the diverse ways we work. If you have a disability and need an accommodation regarding our recruiting process, please let us know by emailing . #LI-RS1 #LI-REMOTEPlease see job descriptionPI182815467

Keywords: PowerSchool, Roanoke , Cloud Operations DBA II, Other , Roanoke, Virginia