logo

SQL Server Developer

San Francisco, CA

Job Description

SQL Server Developer - Full time, salary position

Location: San Francisco, CA

Type: FTE preferred but will consider CTH

Interview: Phone then F2F

Work auth: GC and Citizens preferred

 

MUST HAVE A BANK, FINANCIAL, OR CREDIT UNION BACKGROUND


Key Responsibilities

• Ability to work in agile, collaborative team environment

• Provide technical support of financial production applications and database systems.

Work off hours to provide support to software applications or system maintenance.

• Monitor database application systems for performance, system errors, and system vitals

and troubleshoot any issues

• Deploy SQL code and Application updates from development to production

environments as needed

• Build ETL processes and reports as needed

• Migrate, consolidate, and update batch processes and SQL procedures

• Analyze, document, and re-engineer outdated batch scripts and processes into

streamlined, highly effective, well documented and supportable job processes

• Design and implement data management solutions

o Relational database design and development (OLTP databases)

o Analytical and reporting database design and implementation (OLAP/Memory

resident/NoSQL)

Qualifications & Required Skills

• Experience in monitoring and troubleshooting complex application integrations and

database environments

• Excellent ability to quickly distinguish between database and application support issues

and learn systems/processes by reading the code

• Excellent ability working with application vendors to help troubleshoot and resolve any

production issues

• Writing TSQL scripts and stored procedures for production jobs

• Experience with SSIS for creating ETL packages

• Solid acquaintance with Windows Server 2003/2008, Security Delegation, SPNs, storage

components Creating SQL Agent jobs and effective use of Powershell/batch scripting as

needed in SQL Server jobs• Installing and configuring any version of SQL Server on development and production

servers

• Demonstrate the knowledge and ability to perform in all of the basic database

management skills of database administration, physical structure, overall architecture,

and database analysis

• Provide recommendations for standardization and consistency across environments

• Ensure a stable and secure database and application environment

• Implement and monitor database functionality to ensure stable environments

• Uphold enterprise policy guidelines and recommend new/improved guidelines

• Partner with project teams and interact with customers to find solutions for projects

and operational issues for existing and proposed databases

• Demonstrated ability to define and follow best practices and business processes

• Exceptional customer-service orientation. Work well in diverse multicultural

environment

• Excellent oral and written communication skills

• Strong analytical and troubleshooting skills

• Interest in pursuing deep financial application and database expertise

• Experience with Charles River or another OMS Trading Platform, Microsoft Solomon or

Great Plains, Advent Axys or Geneva, Concur, Datawatch Monarch, Factset, Bloomberg,

Eagle.

Experience & Education

• Bachelor's Degree in Computer Science, Engineering, or related field

• A minimum of 5 years of combination application and database administration

experience in a production environment

• 3-5 years managing MS SQL RDBMS, Reporting Services and other SQL Server related

services from a Production Support level

• 3-5 years using Performance Monitor, SQL Profiler and other related monitoring and

troubleshooting tools

• 3+ Years of solid understanding of performance tuning, and database system

optimizations

• Strong technical knowledge of SQL, Powershell, batch scripting

• Must be well versed in basic web technologies and database reporting for production

support

• Microsoft certified

Qualifications

US APPLICANTS ONLY