Sr. SQL DBA Engineer
Company Overview
For over 29 years, we have been a leader in the stock brokerage industry because of our commitment to innovation, value and service. We are unique because we offer self-directed investors low fees, as well as, the largest nationwide network of local branch offices among online brokerage firms.
In 2008, we earned the J.D. Power and Associates award for "Highest in Investor Satisfaction with Self-Directed Services.
In 2008 and 2009, Fortune Magazine ranked us as one of the "Best Companies to Work for in America.
To learn about who we are, visit us online.
Job Description
Scottrade, Inc. has a Sr. SQL DBA Engineer position available in St. Louis, MO. The main purpose of this position is to plan, implement, support, monitor, design and maintain departmental and enterprise database management in a Microsoft SQL clustered environment. This position will oversee the migration of database structures from development and QA environments into the production environment. This position will manage all environments and report capacity and performance results to senior management. Strong scripting, stored procedure and query skills are required. This position will ensure the integrity and backup of all production and development data. The incumbent must have extensive experience with disaster recovery and data replication techniques.
Responsibilities:
- Installs, configures, and administers database management clustered systems, utilities, and tools in MS SQL 2005 and 2008 environments.
- Develops and maintains standards, procedures, and methodologies for effective operation, access, control backup and recovery of all database systems.
- Provides technical expertise and performs tasks for all related infrastructure projects, including business continuity and disaster recovery.
- Enforces, manages and creates policies and procedures.
- Provides all support related issues for production, QA, and development database (24x7).
- Works closely with business and IS associates and outside vendors to effectively plan, deploy and update database environment additions and changes.
- Perform other duties as assigned.
Knowledge, Skills and Abilities:
- Comprehensive knowledge of relational data base design, testing and implementation
- Working knowledge of MS Office suite of products, including MS Project, Visio, and Visual Source Safe.
- Solid understanding of storage area networks and network attached storage environments (EMC preferred)
- Project management and documentation skills with great attention to detail
- Excellent organizational skills with the ability to handle multiple tasks
- Basic level proficiency with Microsoft Word, Excel, Access, PowerPoint and Outlook.
- Expert level proficiency with SQL database.
- Basic level proficiency with Oracle database.
- Basic level proficiency with VSS source control systems.
- Basic level proficiency with TCP/IP hardware skills.
- Basic level proficiency with Cisco routers and switches.
- Basic level proficiency with PIX firewalls.
- Intermediate level proficiency with Windows NT servers.
- Intermediate level proficiency with Windows operating systems.
Education and Experience:
- Bachelor’s degree in information technology or equivalent combination of education and experience required.
- 4+ years experience in Microsoft Operating Systems and SQL clustered environments required.
- 4+ years experience in a SQL Server Data Base Administration support and project lead role required.
- 2+ years of experience supporting core Scottrade Trading Systems preferred.
- 2+ years experience supporting geographically dispersed production environments preferred.
- 2+ years of experience supporting HA and DR strategies
Scottrade, Inc., an equal opportunity employer, is committed to inclusion and a diverse workforce.
Job Level: 6-10 Years
Open all references in tabs: [1 - 3]