Every moment of every day, people around the world rely on the energy they access through infrastructure built by Quanta. Comprising the largest skilled-labor force in North America, our employees are highly skilled and innovative, continually working to connect people and power. We’re building the infrastructure that supports the energy transition, and there are more opportunities than ever to be part of our team. Join us and build your career building a brighter future.
Imagine what you could do here. We encourage, inspire, and support our people to seize opportunities in our corporate office and with hundreds of our operating companies worldwide that provide solutions for the utility, renewable energy, electric power, industrial, and communications industries.
Quanta actively promotes and maintains a culture of belonging where all employees can be themselves, live their values, and find opportunities to succeed. When you join our team, you join a dynamic organization in which career development is encouraged, excellence is rewarded, and diversity is prized. Come find out how our people power modern life.
About this RoleThe Database Administrator role is responsible for the availability, security, support and integrity of theQuanta Services database platforms. This includes, but is not limited to, implementation andmaintenance of both SQL and Oracle databases, support to operating units and use of various management tools. The ideal candidate would have a background in database server design and architecture, implementation, database tuning, reporting services and security.
What You'll Do Perform daily DBA tasks, including but not limited to verify daily backups and resolve backup related issues, verify health check by reviewing database alert log errors, and space usage.Confirm off-site sync and database scheduled jobs completed successfullyResolve blocking, deadlocking, log shipping, connectivity or security issuesMonitor database health and performance using Enterprise Manager (13c) or queries and provide recommendations based on monitoring resultsInstall, configure, monitor and troubleshoot MS SQL Server systems in non-clustered and clustered configurations.Keep up with tickets assigned and provide updates frequentlyPractice good communication skills inside and outside the teamParticipate in on-call rotationMaintain database documentation and standardsWork on projects as defined by Manager Database Systems What You'll BringLICENSES / CERTIFICATIONS:
Oracle certified Associate - PreferredMCSA for Microsoft SQL Server – PreferredITIL Foundation – PreferredKNOWLEDGE AND SKILLS:
Experience administering complex 24x7 database environmentsHands On experience with Oracle Version 19cHands On experience with MSSQL Versions (2016, 2017, 2019, 2022)Experience with instance caging and resource management including resource management plan, maintenance window, runaway queries, and CPU limit Good knowledge about partitioning, and compression including Exadata specific compression featureProven experiences with Access Advisor, Segment Advisor, Memory Advisor and other Oracle Advisor toolsFamiliar with user, role and profile management including create/delete/change user privileges, create/delete/redesign roles and profiles. Provide recommendation for user access database design by implementing role-based access.Comprehensive knowledge of RMAN backup and recovery including creating, modifying, and implementing RMAN backup scripts, restoring RMAN backups, managing RMAN retention policy, and other RMAN configurations in Data Guard and non-Data Guard environmentsExperience with flash back and restore points in Data Guard and non-Data Guard environmentsExperience with Data Guard failover/switchover processExperience with AlwaysOn failover processExtensive practice with Enterprise Manager including target management, metric alert management, job management and other database related tools integrated in Enterprise ManagerUnderstand patching procedures including patch search, patch apply procedure, patch rollback procedure and aware of known patch issuesConsiders Oracle best practices as guidelines in all assigned tasks and make good judgements in what can be applied to current environmentsKnowledge about Azure/OCI is a plus. Equal Opportunity EmployerAll qualified applicants will receive consideration for employment and will not be discriminated against on the basis of race, color, religion, national origin or ancestry, sex (including gender, pregnancy, sexual orientation, and/or gender identity), age, disability, genetic information, veteran status, and/or any other basis protected by applicable federal, state or local law.
We are an Equal Opportunity Employer, including disability and protected veteran status.
We prohibit all types of discrimination and are committed to providing access and equal opportunity for individuals with disabilities. For additional information or if reasonable accommodation is needed to participate in the job application, interview, or hiring processes or to perform the essential functions of a position, please contact us the Company’s Human Resources department.
Software Powered by iCIMS
www.icims.com