Job Description :
Primary Responsibilities:
Perform applications database administration( Microsoft SQL server & Oracle) functions including SQL code review, performance analysis, query tuning, database application design, physical data modeling, and developer support
Proactively monitor databases servers and respond to any alerts
Work with development teams in database design process and make suggestions/recommendations based on data manipulation needs of the application.
Works with customers on troubleshooting production issues
Provide database support in all phases of SDLC
Work with team members to come up with solutions in line with group''s standards
Participate in 24X7 on call rotation schedule for various production support, database maintenance, housekeeping and installs
Interface with Operations Database group, Systems Administrators and Capacity Planning groups as and when situation demands
Ability to quickly diagnose the problem areas and come up with solutions and/or workarounds
Evaluation and recommendation of software products in database management arena
Should have strong time management skills with willingness and ability to handle multiple projects/initiatives at the same time
Self-motivated with strong team, interpersonal and communication skills
Setup DR and HA strategy and support routine DR testing
Establish database standards for operations, upgrades, migrations and onboarding new applications and/or clients
Write clear, concise, well organized technical documentation to maintain standards and procedures
Manage various database infrastructure projects
Education and Experience:
B.S./B.A. in Computer Science or Information Systems
SQL Server certification highly desirable, but not mandatory
At least 7+ years’ MS SQL Server DBA experience and/or DBA experience in other DBMS systems ( Oracle, MariaDB , PostgreSQL)
Sybase and Oracle experience is a definite plus
Experience in the Mutual Fund /Financial Services industry is highly desired
Skills and Knowledge:
Extensive experience in MS SQL hands on database administration, database development, and troubleshooting in a complex Windows environment
Strong SQL database administration and SQL engineering experience
Strong T-SQL and query optimization experience to insure high level of performance
Ability to detect and troubleshoot SQL server related CPU, memory, I/O, disk space and other resource contention
Advanced knowledge of SQL Server 2008/2012/2014 database architecture, security, scalability, including replication, clustering, mirroring, and related technologies
2-3 experience in Oracle RAC database administration across multiple platforms AIX, Solaris, Linux and Exadata servers.
Experience in setting up, installing and managing Oracle replication technologies Oracle GoldenGate and Oracle Dataguard; and performing Automatic Storage Management/Replication using Oracle ASM.
Advance skill set in SQL Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools, at least 1year experience in Oracle database performance tuning using Oracle Enterprise Manager Grid control (OEM 12c), Linux shell scripting, and writing database monitoring jobs in PL/SQL.
Strong Database and infrastructure project management skills