Data Engineer (DBA)
Who We Are: Capital One is a technology company, a research laboratory, and a nationally recognized brand with over 65 million customers. We offer a broad spectrum of financial products and services to consumers, small businesses and commercial clients - and data is at the center of everything we do. In December 2015, Capital One was named a Blue Ribbon Company by Fortune Magazine as one of only 25 companies in the world to make their top company lists four times in 2015 (Fortune’s 100 Best Companies to Work For, Global 500, Fortune 500, World’s Most Admired Companies). Capital One was also named as Top Workplace in the Greater Chicago area for 2015 by The Chicago Tribune and 5th among the large companies. Come learn more about the great opportunities we have to offer! The Role:
We are passionate about data! As a Database Administrator at Capital One, you’ll be responsible for administration of procedures and practices regarding data access and upkeep for a specific database technology. This includes working with project teams to determine changes needed to both the database and models, and then implementing those changes. Our DBA’s support ongoing project efforts and day-to-day support activities for the department. If you seek a new challenge in a dynamic company that offers a competitive compensation plan and industry leading benefits, apply today!
- Manage and maintain data in all production and non-production databases and replication servers. Maintain database security; generate reports, queries and documentation. Work with project teams to identify database changes needed.
- Manage database elements, including creation, alteration, deletion and copying of schemas, databases, tables, views, indexes, stored procedures, triggers and declarative integrity constraints.
- Set up access privileges to databases. Create and maintain user profiles for database access, including login and password. Perform backup and recovery, configure database parameters, and prototype designs against logical data models.
- Monitor database and replication servers for resource utilization. Handle testing, reporting, backup/restore. Manage database distribution, security and access requirements.
-Bachelors of Science or military experience
-At least 5 years of experience as a DBA
Unix shell scripting
Experience with Amazon Web Services (AWS), including AWS RDS
Experience with Amazon Redshift a big plus
Experience with Agile methodologies