SQL Server Developer
Vertisystem - San Francisco, CA

This job posting is no longer available on VertiSystem. Find similar jobs: SQL Server Developer jobs - Vertisystem jobs

Job Description

SQL Server Developer
Location: San Francisco, CA
Type: FTE preferred but will consider CTH
Interview: Phone then F2F
Work auth: GC and Citizens preferred

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
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
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
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,
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
Strong technical knowledge of SQL, Powershell, batch scripting
Must be well versed in basic web technologies and database reporting for production
Microsoft certified



Additional Information


VertiSystem - 16 months ago - save job