Overview
On Site
Full Time
Skills
Backup
Recovery
Disaster Recovery
Authentication
Authorization
Encryption
Performance Tuning
Collaboration
NoSQL
FOCUS
Replication
Data Modeling
Log Analysis
Query Optimization
SAN
Command-line Interface
Shell Scripting
Production Support
Linux
Microsoft Windows
Oracle Db
Apache Cassandra
Database Administration
Capacity Management
Interfaces
Relational Databases
Data Integrity
Usability
Quality Control
Auditing
Process Modeling
Normalization
Data Flow
Strategic Planning
IT Infrastructure
Network
Accountability
Reporting
Management
Risk Management
Regulatory Compliance
Business Analysis
Business Analytics
Customer Service
Multitasking
Analytical Skill
Attention To Detail
RDBMS
Microsoft SQL Server
Oracle
Open Systems
Database
SQL
Servers
Data Analysis
Data Mining
Business Intelligence
Data Warehouse
Law
Job Details
Primary Office Location:
626 Washington Place. Pittsburgh, Pennsylvania. 15219.
Join our team. Make a difference - for us and for your future.
**Please note: this position is based on site in Pittsburgh, PA. Candidates must be local or willing to relocate to the area. This position is not available for remote work.**
Position Overview:
This position is primarily responsible for providing advanced database support across the corporation. The incumbent creates, designs, develops, implements and maintains complex databases with respect to access methods, access time, security, device allocation, validation checks, reorganization and statistical methods. This position has a moderate impact on operations, resources and the corporation's reputation.
Primary Responsibilities:
Minimum Level of Education Required to Perform the Primary Responsibilities of this Position:
BA or BS
Minimum # of Years of Job Related Experience Required to Perform the Primary Responsibilities of this Position:
5
Skills Required to Perform the Primary Responsibilities of this Position:
Preferred Qualifications:
Licensures/Certifications Required to Perform the Primary Responsibilities of this Position:
A Cassandra DBA certification is preferred.
Physical Requirements or Work Conditions Beyond Traditional Office Work:
N/A
Position Title: Database Administrator 2
Business Unit: Technology
Reports to: Manager of Database Administration
Position Overview:
This position is primarily responsible for providing advanced relational database support across the corporation. The incumbent creates, designs, develops, implements and maintains complex databases with respect to access methods, access time, security, device allocation, validation checks, reorganization and statistical methods. The incumbent assists with capacity planning and participates in data center related activities like database consolidation and planning. This position has a moderate impact on operations, resources and the corporation's reputation.
Primary Responsibilities:
Maintains and uses database dictionaries. Manages and maintains corporate database systems and develops high level interfaces to databases. Works with relational databases like MS SQL Server, Oracle, and/or other Open system SQL Databases.
Writes high level complex queries from a relational database establishing links between tables and fields, often between systems, and analyzes results. Writes programmatic procedures needed to maintain data integrity and usability.
Is responsible for quality control and auditing of databases to ensure accurate and appropriate use of data. Works with clients with database selection, process definition, data normalization, data flow and proper data usage.
Tracks, monitors and analyzes performance and production issues and implements improvements. Supports and helps manage external resources such as service providers and vendor support. Ensures the collected data is within required quality standards.
Advises on strategic planning for database deployment and integration issues. Assist with complex SQL design and SQL coding. Works closely with other areas of IT infrastructure organizations like Server Engineers and Network Engineers.
Performs other related duties and projects as assigned.
All employees have the responsibility and the accountability to serve as risk managers for their businesses by understanding, reporting, responding to, managing and monitoring the risk they encounter daily as required by F.N.B. Corporation's risk management program.
F.N.B. Corporation is committed to achieving superior levels of compliance by adhering to regulatory laws and guidelines. Compliance with regulatory laws and company procedures is a required component of all position descriptions.
Minimum Level of Education Required to Perform the Primary Responsibilities of this Position:
BA or BS
Minimum # of Years of Job Related Experience Required to Perform the Primary Responsibilities of this Position:
5
Skills Required to Perform the Primary Responsibilities of this Position:
Excellent customer service skills
Ability to use general office equipment
Ability to work and multi-task in a fast paced environment
Excellent organizational, analytical and interpersonal skills
Detail-oriented
Minimum 5 years as a database administrator. Expertise with RDBMS like MS SQL Server, Oracle, and/or other Open system SQL Databases. Knowledge of SQL and SQL coding a must. Knowledge of Servers and Server technology a plus.
Licensures/Certifications Required to Perform the Primary Responsibilities of this Position:
Deep skills in data analysis, data mining, business intelligence and data warehousing.
Physical Requirements or Work Conditions Beyond Traditional Office Work:
N/A
Equal Employment Opportunity (EEO):
It is the policy of F.N.B. Corporation (FNB) and its affiliates not to discriminate against any employee or applicant for employment because of age, race, color, religion, sex, national origin, disability, veteran status or any other category protected by law. It is also the policy of FNB and its affiliates to employ and advance in employment all persons regardless of their status as individuals with disabilities or veterans, and to base all employment decisions only on valid job requirements. FNB provides all applicants and employees a discrimination and harassment free workplace.
626 Washington Place. Pittsburgh, Pennsylvania. 15219.
Join our team. Make a difference - for us and for your future.
**Please note: this position is based on site in Pittsburgh, PA. Candidates must be local or willing to relocate to the area. This position is not available for remote work.**
Position Overview:
This position is primarily responsible for providing advanced database support across the corporation. The incumbent creates, designs, develops, implements and maintains complex databases with respect to access methods, access time, security, device allocation, validation checks, reorganization and statistical methods. This position has a moderate impact on operations, resources and the corporation's reputation.
Primary Responsibilities:
- Deploy, configure, manage, and monitor Cassandra database clusters in production and non-production environments.
- Ensure database availability, reliability, and optimal performance through proactive monitoring and tuning.
- Perform backup, recovery, and disaster recovery planning for Cassandra databases.
- Implement security best practices for Cassandra clusters, including authentication, authorization, and encryption.
- Troubleshoot and resolve database issues, working closely with infrastructure and application teams.
- Support patching, upgrades, and performance tuning of Cassandra clusters.
- Collaborate with development teams to optimize queries, data access patterns, and replication strategies.
- Participate in an on-call rotation to provide 24/7 production support.
- Provide basic support for RDBMS such as SQL Server.
Minimum Level of Education Required to Perform the Primary Responsibilities of this Position:
BA or BS
Minimum # of Years of Job Related Experience Required to Perform the Primary Responsibilities of this Position:
5
Skills Required to Perform the Primary Responsibilities of this Position:
- Minimum 5 years of experience as a NoSQL DBA with a strong focus on Cassandra database administration.
- Hands-on experience managing Cassandra clusters, including replication, consistency tuning, and compaction strategies.
- Strong knowledge of CQL (Cassandra Query Language) and data modeling best practices.
- Proficiency in troubleshooting performance issues, log analysis, and query optimization.
- Experience in infrastructure-level database administration, including storage, networking, and system-level troubleshooting.
- Familiarity with Linux-based environments, including command-line operations and shell scripting.
- Knowledge of monitoring tools such as DataStax OpsCenter.
- Willingness to participate in on-call rotation for production support.
- Comfortable working in both Linux and Windows environments.
- Ability to work and multi-task in a fast paced environment.
- Excellent organizational, analytical and interpersonal skills.
Preferred Qualifications:
- Experience working with DataStax Enterprise (DSE) Cassandra.
- Basic understanding of RDBMS concepts (SQL Server, Oracle, DB2).
- Knowledge of containerized environments and their impact on database deployments.
Licensures/Certifications Required to Perform the Primary Responsibilities of this Position:
A Cassandra DBA certification is preferred.
Physical Requirements or Work Conditions Beyond Traditional Office Work:
N/A
Position Title: Database Administrator 2
Business Unit: Technology
Reports to: Manager of Database Administration
Position Overview:
This position is primarily responsible for providing advanced relational database support across the corporation. The incumbent creates, designs, develops, implements and maintains complex databases with respect to access methods, access time, security, device allocation, validation checks, reorganization and statistical methods. The incumbent assists with capacity planning and participates in data center related activities like database consolidation and planning. This position has a moderate impact on operations, resources and the corporation's reputation.
Primary Responsibilities:
Maintains and uses database dictionaries. Manages and maintains corporate database systems and develops high level interfaces to databases. Works with relational databases like MS SQL Server, Oracle, and/or other Open system SQL Databases.
Writes high level complex queries from a relational database establishing links between tables and fields, often between systems, and analyzes results. Writes programmatic procedures needed to maintain data integrity and usability.
Is responsible for quality control and auditing of databases to ensure accurate and appropriate use of data. Works with clients with database selection, process definition, data normalization, data flow and proper data usage.
Tracks, monitors and analyzes performance and production issues and implements improvements. Supports and helps manage external resources such as service providers and vendor support. Ensures the collected data is within required quality standards.
Advises on strategic planning for database deployment and integration issues. Assist with complex SQL design and SQL coding. Works closely with other areas of IT infrastructure organizations like Server Engineers and Network Engineers.
Performs other related duties and projects as assigned.
All employees have the responsibility and the accountability to serve as risk managers for their businesses by understanding, reporting, responding to, managing and monitoring the risk they encounter daily as required by F.N.B. Corporation's risk management program.
F.N.B. Corporation is committed to achieving superior levels of compliance by adhering to regulatory laws and guidelines. Compliance with regulatory laws and company procedures is a required component of all position descriptions.
Minimum Level of Education Required to Perform the Primary Responsibilities of this Position:
BA or BS
Minimum # of Years of Job Related Experience Required to Perform the Primary Responsibilities of this Position:
5
Skills Required to Perform the Primary Responsibilities of this Position:
Excellent customer service skills
Ability to use general office equipment
Ability to work and multi-task in a fast paced environment
Excellent organizational, analytical and interpersonal skills
Detail-oriented
Minimum 5 years as a database administrator. Expertise with RDBMS like MS SQL Server, Oracle, and/or other Open system SQL Databases. Knowledge of SQL and SQL coding a must. Knowledge of Servers and Server technology a plus.
Licensures/Certifications Required to Perform the Primary Responsibilities of this Position:
Deep skills in data analysis, data mining, business intelligence and data warehousing.
Physical Requirements or Work Conditions Beyond Traditional Office Work:
N/A
Equal Employment Opportunity (EEO):
It is the policy of F.N.B. Corporation (FNB) and its affiliates not to discriminate against any employee or applicant for employment because of age, race, color, religion, sex, national origin, disability, veteran status or any other category protected by law. It is also the policy of FNB and its affiliates to employ and advance in employment all persons regardless of their status as individuals with disabilities or veterans, and to base all employment decisions only on valid job requirements. FNB provides all applicants and employees a discrimination and harassment free workplace.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.