Google Cloud Database Administrator

About the role

This individual will be responsible for administering and implementing database solutions while providing system operational support, administration, problem resolution, and perform software installations and upgrades on our database systems concentrating on Google Cloud Platform and other cloud-based solutions (up to 30%). The Database Administrator will be expected to exhibit strong troubleshooting techniques while striving to maintain a high level of customer satisfaction.

Responsibilities

• Responsibility for all enterprise database technology deployed in the cloud including various versions of Microsoft SQL Server and other database platforms including features such as the core database engine, reporting, data loading and transformations, business intelligence, replication technologies and other modules.
• Perform configuration and maintenance of database platforms, including patching.
• Monitor database instances for performance, utilization, and capacity.
• Work with application teams when appropriate to address issues.
• Manage maintenance plans, backups, and automated jobs.
• Responsible for the database platform security model, including using Active Directory-integrated accounts in a multi-forest environment where appropriate.
• Responsible for query writing and optimization.
• Responsible for database schema design.
• Develop, administer, and optimize Google BigQuery datasets, tables, views, partitioning, clustering, permissions, scheduled queries, and data pipelines to support reporting, analytics, and operational workloads.
• Support BigQuery SQL development, performance tuning, cost optimization, data governance, access controls, and integration with Google Cloud services, business intelligence tools, and enterprise data platforms.
• Leverage automated alerting to be notified of issues as they happen. Tune alerts to reduce noise.
• Responds to incoming phone, email, or web-reported technical issues from internal users related to network and infrastructure, and assists in troubleshooting database issues as well as application issues for which the database may be a contributing factor.
• Identifies severity and impact and documents details in the Help Desk call tracking system.
• Works in partnership with all IT teams to find solutions, and/or escalates issues to appropriate IT groups for resolution.
• Communicates status and updates to end users in a timely and consistent manner.
• Sets priorities for open issues and escalates issues to the correct department for resolution.
• Follows through with closure of user issues.
• Recreates problems in development environments for troubleshooting and resolution when needed.
• Creates and documents workarounds.
• Aid in training.

Qualifications

• 7+ years of experience in database administration in a cloud-based enterprise environment, preferably across multiple versions of cloud providers using multiple database platforms.
• Administrative knowledge of Active Directory and other forms of database security.
• Scripting and automation experience.
• Demonstrated excellent verbal and written communication skills.
• Demonstrated strong customer service and analytic skills.
• Demonstrated ability to think through sets of complex problems, create and implement appropriate solutions.
• Prominent ability to establish and maintain effective professional working relationships.
• Ability to think and work independently.
• Ability to adapt and learn in a fast-paced, changing environment.
• Administration experience in backup technologies that can be used to back up various database platforms.
• Additional experience in Disaster Recovery technologies a plus.