Senior leader in database platform engineering driving enterprise data solutions at LPL Financial. Lead infrastructure transformation and establish data architecture strategy for on - prem and hybrid - cloud.
About the role
- Database Administrator managing SQL Server installations, backups, performance tuning, and security. Collaborating with stakeholders to meet database requirements.
Responsibilities
- Database Installation and Configuration: Configuring SQL Server software on servers post Installation and ensuring proper configuration settings for optimal performance and security.
- Database Maintenance: Performing regular backups, restoration, and recovery of databases to ensure data integrity and minimize downtime in case of failures.
- Database Monitoring and Performance Tuning: Monitoring the performance of databases, identifying and resolving performance issues, optimizing queries, and fine-tuning server configurations to ensure efficient and smooth operation.
- Security and Access Management: Implementing security measures such as user authentication, authorization, and auditing to protect sensitive data. Managing user access, roles, and permissions within the database.
- Database Troubleshooting: Investigating and resolving database-related issues, such as connectivity problems, data corruption, and performance bottlenecks. Applying patches and fixes to address bugs and vulnerabilities.
- Database Documentation: Maintaining accurate and up-to-date documentation of database configurations, procedures, and troubleshooting guides to ensure easy reference for future tasks and knowledge sharing.
- Database Capacity Planning: Monitoring database growth and resource utilization to anticipate and plan for future storage requirements and performance enhancements. Making recommendations for hardware upgrades or additional resources as needed.
- Disaster Recovery Planning: Developing and implementing disaster recovery strategies and procedures to ensure business continuity in case of system failures or disasters. Testing and validating backup and recovery processes regularly.
- Collaboration and Communication: Collaborating with application developers, system administrators, and other stakeholders to understand and address their database requirements and concerns. Communicating effectively to provide timely updates and resolutions.
- Continuous Learning: Keeping up-to-date with the latest SQL Server features, best practices, and industry trends. Participating in training programs, attending conferences, and exploring relevant resources to enhance your skills and knowledge.
Requirements
- 5 years of database related experience required
- High school diploma or equivalent required. Bachelor’s degree in Computer Science, Computer Information Systems, Management Information Systems, or a directly related field.
- A certification in databases management would be appropriate
- Good analytical and problem-solving skills.
- Ability to demonstrate understanding of SQL Database Management System application's architecture, data structures, and functionality.
- Proficient in SQL database engine administration, setup and maintenance of user and group security.
- PowerShell and T-SQL Scripting: Learn PowerShell scripting to automate administrative tasks in SQL Server. Also, have a strong understanding of T-SQL (Transact-SQL) scripting language to write complex queries, stored procedures, and functions.
- SQL Server Upgrades and Migrations: Understand the process of upgrading SQL Server to newer versions and migrating databases to new servers. Familiarize yourself with the associated risks and best practices.
- Best Practices and Industry Standards: Stay updated with the latest best practices, industry standards, and security guidelines for SQL Server. Follow Microsoft's official documentation and online resources to ensure you're using recommended practices.
- Good written and verbal communication skills. Ability to communicate technical info and ideas so others will understand.
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
Principal Database Administrator providing DBA support for Oracle, SQL Server and Snowflake data warehouses. Working closely with business units for onboarding data into the Enterprise Datawarehouse Snowflake DB platform.
Senior Database Administrator managing PostgreSQL and Oracle databases at Marsh McLennan. Leading complex database migrations and optimizing performance in cloud environments.
Database Administrator managing database environments for Northrop Grumman. Collaborating with a team to achieve high availability and security at Ohio's NASIC facility.
Principal Database Administrator for Northrop Grumman managing databases and supporting modernization efforts at NASIC in Ohio. Requires citizenship and technical expertise in various database systems.
Database Administrator handling database systems for the Teachers’ Retirement System of Illinois. Supporting software development life cycle and providing database administration tasks primarily on SQL Server.
Senior Oracle Database Administrator managing and optimizing mission - critical Oracle database environments. Focusing on performance, resilience, and collaboration with teams in disaster recovery operations.
Database Administrator managing Oracle Primavera P6 databases at Westinghouse. Ensuring data integrity and system availability for project management in the energy sector.
Database Administrator supporting high - visibility mission critical customer at MetroStar. Developing applications and managing database systems with a highly qualified technical team.
Database Administrator managing Oracle Primavera P6 databases, focusing on installation, security, and user support for effective project management solutions at Westinghouse.