Job Description
Job Title: Senior Database Developer Job ID: 100052
Location:
Full/Part Time: Full-Time
Regular/Temporary: Regular
Manager level: Second Level Professional
A leader in brokerage and investment services for over 35 years, TD Ameritrade offers a full spectrum of powerful solutions and innovative tools for trading and investing. We're constantly expanding our knowledge and bolstering our capabilities, from a leading active trader program to intuitive long-term investment solutions and a national branch system. Combined with some of the industry's brightest minds, there's no limit to how big our accomplishments can be.
From first-time investors to sophisticated traders, TD Ameritrade is focused on helping individuals seek out their financial goals. And you're the ambassador to all that we do. Beginning with our trading platform and proprietary technology to our resolve to outperform, you'll maintain the high level of quality and integrity we're known for, each and every day. With the right opportunity, there's no limit to what you can accomplish.
As a leading employer in financial services, we believe in building strong relationships, achieving quality results and working with integrity. It's at the heart of everything we do. That's why we provide you with comprehensive training, benefits and programs that inspire you to achieve more every day. Apply to a TD Ameritrade job today and help our clients pursue their dreams, while you fulfill yours.
Applicants must be eligible to work in the U.S. Immigration sponsorship is typically not available for this position.
Role:
As a Senior Database Developer, you will be responsible for supporting databases and ensuring their performance and availability. You will be working in an energetic, fast-paced team environment where excellence is the norm. You will be responsible for developing efficient, scalable, highly available database applications. You will be involved at all levels: executing on technical tasks and influencing at the higher levels for critical long-term success of the applications.
Responsibilities:
- Perform product analysis and development tasks of complex nature which may require extensive research under guidance of the technical lead.
- Work independently in the design, development, testing, implementation and maintenance of systems of moderate size/complexity with a fast turn-around.
- Provide well-articulated detailed analysis of problems and recommend solutions.
- Apply innovation, creativity and improvement to the development process and problem-solving, keeping abreast of new technologies.
- Participate in the creation of detailed design documents for major applications.
- Able to work on multiple projects at the same time and direct offshore resources.
- Provide high-quality support for various applications and be proactive in keeping applications stable and reliable.
Requirements:
- Excellent verbal/written communication skills.
- Ability to work with others in a team environment.
- Ability to contribute to the creation of business requirements and programming specifications. Requires the ability to anticipate issues and recommend solutions.
- Ability to create, modify or support existing database objects and stored procedures. Able to perform query optimization, and determine proper indexes
- Knowledge of database design and object-oriented design principles and common design patterns relating to object persistence.
- Ability to work on aggressive project schedules and support a production environment. May occasionally require work beyond normal hours (weekends or evenings).
- Confer with system analysts, managers, technical personnel and customers to resolve problems of intent, inaccuracy or feasibility, output requirements, input data acquisition, coding use and modifications and inclusion of internal checks and controls.
- Scripting language skills, such as PERL, VBScript is a strong plus.
- Experience with clustering
- Ability to troubleshoot production issues, by debugging tools, profilers required.
- Significant exposure to and demonstrated proficiency in all aspects of database programming and analysis, including design factors, software requirements, systems facilities, and execution protocols. Performance tuning is a definite requirement.
- Strong skills to work with XML datasets. Able to write applications that manipulate XML using the .NET framework, or to be loaded /extracted from SQL.
- Strong relational database design skills. Knowledge of T-SQL to investigate data issues and write stored procedures.
- 8+ years' experience as a SQL server database developer. Experience with SQL Server [2000, 2008] is required.
- Experience with SQL Server Integration Services (SSIS), SQL Server Reporting Service (SSRS) and SQL Agent.
- Experience with Windows desktop operating systems and Windows Server 2003 management and application trouble-shooting
- Experience with Data Transformation Services (DTS), Unified Modeling Language (UML), Team Foundation System is a plus.
- DB Administration skills are a plus.
- Experience with Oracle Database technology is a plus.
- Experience in the brokerage industry/financial background experience is a plus.
- 4 year degree in Computer Science or related experience.
TD Ameritrade participates in the E-Verify program for those states requiring E-Verify. For additional information on this program please click here.
TD Ameritrade is an Equal Opportunity Employer. We value diversity and offer a quality workplace.
TD Ameritrade, Inc. member FINRA/SIPC/NFA is a subsidiary of TD Ameritrade Holding Corporation (NASDAQ: AMTD). TD Ameritrade is a trademark jointly owned by TD Ameritrade IP Company and the Toronto-Dominion Bank. © 2012 TD Ameritrade IP Company, Inc. All rights reserved. Used with permission.