Database & Application Administrator II

Marketing Statement The Database & Application Administrator ll reports to the Vice President of IT Infrastructure. The Database and Application Administrator II provides operational database management services and maintaining ERP software applications for the Philadelphia Housing Authority's ISM Department. Annual salary range: 470,965 - $84,271 Qualifications Education, Training and Experience Guidelines: Bachelor's Degree in Computer Science, Information Systems, or a closely related field; AND four (4) or more years database management experience; OR an equivalent combination of education, training and experience. Preferred education and experience Master's degree is preferred Required Knowledge of: Practices of database administration, including data communications protocols, security procedures, and system components; system access and security guidelines and procedures; troubleshooting techniques for multiple network operating domains, relational databases, and web- and windows-based software applications; the design and integration of relational databases, MS Windows and SQL applications, database operating systems, and other technical applications unique to PHA; database performance tuning techniques, and backup and recovery procedures; networked computer system environments and device capabilities; maintenance standards for relational databases, network operating systems, and servers; project planning and management principles. Required Skill in: Analyzing database issues, evaluating alternatives, and developing solutions based on findings; researching, analyzing, and evaluating computer database applications, procedures, and techniques, including data attribute management; installing, maintaining, modifying, and upgrading database systems; and identifying and resolving computer database security problems in a multiple operating system environment; analyzing equipment and system malfunctions, troubleshooting computers and software applications, and determining effective solutions; coordinating the implementation of technology projects; using initiative and independent judgment within established procedural guidelines; assessing and prioritizing multiple tasks, projects and demands; interacting with people of different social, economic, and ethnic backgrounds; establishing and maintaining effective working relationships with co-workers; communicating effectively verbally and in writing. LICENSE AND CERTIFICATION REQUIREMENTS: A valid Commonwealth of Pennsylvania Driver's License may be required. Microsoft, Cisco, Oracle, and other professional IT certifications are desirable. PHYSICAL DEMANDS AND WORKING ENVIRONMENT: Work is performed in a standard office environment. Physical dexterity is required to work in confined spaces and use precision tools and equipment; requires vision capacity to perform fine calibrations and differentiate between colored wires. Responsibilities Administer database infrastructure which includes capacity planning and building virtual machine instances, and physical servers; evaluates and analyzes database issues and recommends and implements solutions; manages and maintains databases; assesses database capacity and utilization trends and recommends hardware improvements; manage backup and restore of databases; identifies performance issues and carries out Performance Tuning; participate in database software products evaluation; monitors database management systems (DBMS) and data reporting platforms across the Solution Deployment Life Cycle (Development, Test, Production) and ensures that they perform within the expected service level; execute the established database operation policies, procedures and processes; understand and execute the database security policies, procedures and processes; perform reliable backup and restore operations that meet the operations level requirements; shares technical knowle ge with the Database Group team; performs various data management operations and configurations: Data ETL (extraction, transformation and load), data replication, data profiling, etc; participates and supports in ERP changing events such as Oracle PeopleSoft ERP, ARMS, Emphasys Elite application software and Microsoft products such as IIS servers, Remote Desktop Servers; participates in the collection of database operations metrics for reports and capacity planning; participates in the database operation cost accounting and budgeting process; performs general Database Administration: DBMS software install, object management, startup and stoppage, patching and upgrade, etc; writes database and reporting systems operations automation scripts; create and maintain documentation on architecture, standards, and processes; trains, and provides guidance and mentorship to DAA I; provides support during afterhours and holidays this includes during patching, or system crashes; maintains absolute confidentiality of work-related issues and PHA information; performs related duties and responsibilities as assigned; participates in an afterhours and on-call activities during critical service disruptions; undertaking of IT related assignments, as directed; other duties as assigned. How To Apply All applications will be accepted through the Philadelphia Housing Authority's Jobs Board at www.pha.phila.gov/jobs Closing Statement About the Philadelphia Housing Authority (PHA) Established in 1937, and with an employment workforce of over 1,100, the Philadelphia Housing Authority is a municipal agency providing public housing services to over 76,000 residents in the city of Philadelphia, Pennsylvania. Financial support for Authority operations and capital needs comes primarily from rent payments and subsidies provided by the U.S. Department of Housing and Urban Development (HUD). PHA is one of a very select group of housing authorities across the nation that has attained Moving to Work (MTW) status. This designation allows housing agencies the opportunity and flexibility, on a local level, to develop and implement innovative housing and self-sufficiency strategies to benefit public housing residents and Housing Choice Voucher Program (HCVP) participants. PHA is an equal opportunity employer and makes all employment decisions on the basis of individual qualifications without regard to race, creed, color, sex, sexual orientation, gender identify, pregnancy, national origin, ethnicity or ancestry, religion, age, disability, citizenship, marital status, military or veteran status, genetic information, or any other protected characteristic.