Database Administrator

Symmetrio is actively recruiting for a Database Administrator for our customer, a large government organization in Philadelphia, PA. The Database Administrator will act as a supportive onsite role to the Platform Engineering team with a primary focus on performing highly technical SQL backend administration in two key areas: SQL systems (including Application, Database, Network, and Server) and SQL security (including CJIS/Cyber Security and Access Control). The individual will be responsible for installing, maintaining, and administering databases and SQL instances, ensuring they are secure, consistent, and operational. The Database Administrator will be expected to take proactive steps to manage database performance and optimization across SQL environments for uptime consistency and develop comprehensive backup/restoration models for application databases.

Responsibilities

• Provide database administration services, including script and instance creation, modeling, modification, copying schemas, tables, views, indexes, stored procedures, triggers, and integrity constraints for moderate to complex issues and systems.
• Document, implement, maintain, and support deployment and monitoring of moderate to complex database systems.
• Plan and conduct database system tests and implement corrective actions to ensure all database servers meet or exceed documented service levels.
• Configure and customize moderate to complex search features, queries, and solutions.
• Create, manage, modify, and/or convert SQL reports, extracts, or ETLs.
• Participate in assigned application projects as a member, with the potential to function as a lead.
• Recommend, document, and communicate administration best practices for data integrity.
• Conduct periodic software audits of database products for compliance with standard policies and procedures.
• Identify new initiatives and recommendations for database growth and integration.
• Monitor database performance metrics to implement tuning and improvements.
• Design, implement, and validate data backup, archive, and recovery workflows.
• Perform additional duties of a Database Administrator as required.

Requirements

• At least 5 years of experience in administration and management of database platforms and application backend infrastructure
• Expertise in MS SQL Server platform and modules, including SSRS/PBIRS, 'Always on' clusters, 'Replication', and 'Auditing'
• Working knowledge of Oracle platforms and products, including Dataguard
• Strong understanding of alternative SQL platforms and products, including PostgreSQL, Sybase, AzureDB, MariaDB, Business Objects, Power BI, or similar
• Working knowledge of Data Warehousing concepts
• Firm grasp on IT network architecture and server operating systems (Windows Server and Linux)
• Ability to carry out administrative and technical communication orally and in writing
• Strong documentation and presentation skills for data concepts and models
• Knowledge of ITSM/ITIL concepts and processes (Incident Management, Change Management, Problem Management, Release Management, etc.)
• Knowledge of Information Security Concepts, including Identity and Access Management
• Ability to work independently and engage in self-learning

Benefits

• Health Care Plan (Medical, Dental & Vision)
• Retirement Plan (401k, IRA)
• Paid Time Off (Vacation, Sick & Public Holidays)