Database Administrator
Database Administrator FHLBank Pittsburgh, PA to be responsible for implement & coordinating Bank’s complex database system & data dictionaries & assisting in coordination of DBA issues with Bank’s Data Service Team & other IT Groups, including Applications development, QA, Client/Server Teams, Networks & Security, & Operations. Specific job duties including anal. database requirements of business units & provide design, installation, configuration, security, resource monitoring & reporting, performance tuning, troubleshooting, & the development of specialized database system; participating in development & maintenance of strategic, architectural, & tactical plans for Bank's database & data warehouse environments; recommending, testing, & evaluate new technologies, software tools, require skill sets. Bachelor’s degree in Computer Science or Engineering, plus 5 years of previous progressively responsible work experience in the position offered or related. Must know (through academic training or work experience) Spotlight & SolarWinds tool, ACTIVE/PASSIVE Clustering, Mirroring, SQL developer & TOAD for Oracle; installing & mounting MS SQL Server 2017/2016/2014/2012 on Windows 2016/2012 servers; SQL 2017, 2016, 2014, 2012 Active/Passive cluster environments for production servers; SQL server 2005/2008 R2 refresh projects which are migrated to SQL server 2012 & SQL 2014 servers; deployment of SSIS packages & SSRS reports through SQL server data tools in SQL 2016, 2017 & 2019 environments; quarterly SQL server patching for 2017/2016/14/12 versions; troubleshooting methods & resolving database performance & deadlocking issues; Oracle 19c DB & ASM administration; creating scripts & scheduling backups in cron for RMAN database backups & recoveries; using Oracle Data pump Exports/Imports utility for moving data among servers; creating & mounting DB on OCI platform; & writing/editing UNIX Shell Scripts.