Kforce has a client in search of a Senior Database Developer in Los Angeles, California (CA).
The Senior Database Developer is responsible for expert knowledge in analysis, design, documentation, development, unit testing, and support of database objects development software applications. The Senior Database Developer must be able to standardize all database related objects and processes, while holding the entire team accountable for following standards by providing support and guidance regarding T-SQL best practices and development standards, follow approved Agile methodologies, leading the design and development efforts for the agile team, create system monitoring solutions to be always aware of system performance, and take initiative to improve quality, maintainability and performance of the system.
The Senior Database Developer will report to the Development Manager directly and Director of Product Delivery indirectly.
In this capacity, the Senior Database Developer will:
Design and develop scalable, performance aware database objects and supporting database markup language (DML) scripts (i.e., stored procedures, indexes, views, functions, data manipulation)
Perform business requirements analysis and translate to technical design; Create and propose technical design through technical documentation and technical conversations
Design, develop and deploy reports to SSRS
Design, develop and deploy ETL processes through SSIS procedures
Maintain and regularly update database coding standards; Provide guidance, training, and mentoring to all application development team members of standards and best practices
Create performance monitor solutions to report daily, weekly and monthly performance of all DML; Use reports to performance tune DML to improve application performance
Author database test harness to support developers and QA engineers, unit-test cases, and automated tests
BA/BS degree required
Microsoft certifications (i.e., MCSA, MCDBA)
Minimum five years of experience with MS SQL Server 2008/2014 development including ETL
At least 2 years of technical experience, developing and supporting business applications
Experience working with C#/.NET technologies; Strong understanding and experience working in a MS Full Stack environment
Experience with advanced query design, stored procedures, views and functions
Experience with Application Lifecycle Management software (e.g., TFS, ClearCase/ClearQuest, JIRA)
Experience managing timelines and task priorities - Strong quantitative, analytical, problem solving, organizational, communication and interpersonal skills are required
Advanced knowledge of T-SQL including complex SQL queries (ex: using various joins and sub-queries) T-SQL performance tuning techniques and best practices
Familiarity with RDBMS principles, database design and normalization
Demonstrated technical leadership, attention to detail and maintaining high quality standards is a must
Demonstrate proficient understanding of OLTP, OLAP, Data Warehouse and BI best practices; Must have experience working with replication, log shipping, offload batch processing, and process queues
Must be able to effectively communicate technical information to both technical and non-technical personnel
Strong interpersonal skills - must be able to work effectively as part of a project team and foster team co-operation
Exposure to Database Administration i.e., Replication, Backup/Restore strategies, Clustering, Log-shipping a plus
Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.
Careers.org gives you access to over a million jobs and career opportunities across the US including in Los Angeles. Find your perfect job and apply directly through a simply online application process