Senior Database Administrator @ DUFF

Job Description

Senior Database Administrator at DUFF & PHELPS, LLC SEARCH JOBS AT DUFF & PHELPS
Our professionals balance analytical skills, deep market insight and independence to deliver solid, defensible analysis and practical advice to our clients. As an organization, we think globally. We create transparency in an opaque world, and we encourage our people to do the same. That means when you take your place on our team, you ll discover a supportive and collaborative work environment that empowers you to excel. If you re ready to share your perspective with the world, then you can make a real impact here. This is the Duff & Phelps difference.
A true partner within the business, our IT team works globally as one cohesive unit comprised of collaborative professionals who take pride in support and customer service. Core areas include solutions delivery and application development, network operations, workforce services and information services/ knowledge management.
At Duff & Phelps, your work will help protect, restore and maximize value for our clients. Join us and together we ll maximize the value of your career.
RESPONSIBILITIES:
The Senior Database Administrator will be assigned to work with one or more development project teams. In this role they will be expected to:
The System Engineer will be responsible for building, supporting and managing end-to-end solutions within Amazon AWS and Azure Cloud environments.
Support SCRUM teams in an Agile development environment.
Working with the Solutions Designer, Development Architect and third parties as appropriate, the engineer will be responsible for ensuring that a technical design document describing the technical architecture for the program/ project is produced.
Understand the business and application requirements and translate into a database design.
Ensure that all technology selected for the program conforms to the organizations technical long-term strategy.
Be responsible for the availability, stability, recoverability and performance of the database environment by ensuring all systems are monitored, patched, and operating optimally.
Design and develop complex SQL queries and appropriate database code such as stored procedures, triggers, functions to support complex business processes.
Develop and deliver extensible/ sustainable/ quality database solutions based on defined business needs.
Review and update stored procedures for optimal performance. Identify and correct performance bottlenecks related to SQL code.
Recommend changes to the relational data model to solve performance issues with SQL code. Requires a solid understanding of relational database design and concepts.
Monitor and troubleshoot SQL jobs using available tools such as SQL Profiler, Quest Spotlight, review logs and triage issues.
Participate in the resolution of production data issues.
Perform code reviews, providing feedback in a timely manner. Incorporate feedback from code reviews as appropriate.
Participate in the review of all database schema projects; provide feedback and identify impacts to existing environment.
Monitor business data stored in production databases, ensuring integrity of the data is maintained.
Responsible for developing, maintaining and deploying SSIS packages.
Participate in release of all stored procedure projects; including release documentation.
Maintain knowledge as new versions of SQL Server are released and leverage new functionality as appropriate.
Proactively identify and act on opportunities to improve database systems and processes.
Contribute to standards documentation for database coding practices.
Prioritize multiple tasks so that aggressive deadlines are met.
Provide ongoing suggestions for improvement and innovation within the department.
Exhibit sound, methodical engineering judgment, and effectively manage trade-offs in a business environment.
Familiar with one or more of the below or other programming languages : VBScript, JavaScript, VB, Java, . NET, PERL
Maintain and exhibit knowledge of AWS RDS, Azure SQL and NOSQL database
Provide after-hours support as required to address system outages and perform system updates/ upgrades/ modifications.
Identify new processes or modify existing processes to improve efficiencies in the support and monitoring of the department s production applications.
Perform other duties as required.
REQUIREMENTS:
B. S. Degree in Information Technology, Computer Science or a related discipline is preferred.
MCSE, AWS Certified
8+ years of experience in database development and support in MS SQL Server environments
3+ years working experience in deploying physical and cloud instances of SQL Server. (AWS preferred)
Working knowledge in at least one other RDMS and noSQL database technology.
3+ years of experience in scripting language like Powershell, VB Script, Python, or similar.
Experience in troubleshooting and resolving database integrity issues, performance issues, blocking & deadlocking issues, replication/ log shipping issues, network/ connectivity issues, security issues, etc.
Experience in Performance Tuning, Query Optimization using SQL Monitor, New Relic, and other related tools
Ability to detect and troubleshoot SQL Server related hardware resource contention such as CPU, memory, disk IO, etc.
Solid acquaintance with windows server, security models, and storage components such as SAN.
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
Advanced experience with TSQL language and stored procedures, transactional replication, multi node clustering, mirroring, etc.
Knowledge of Data Warehousing and Column store databases.
A broad understanding of enterprise-class technologies
Extensive knowledge and experience with large scale client facing online systems
Extensive knowledge and experience with Amazon AWS technologies
Extensive knowledge and experience with Windows based technologies
Ability to communicate and to interact effectively with co-workers and customers is required.
Ability to work and adapt in a dynamic environment and recognize priority issues, escalating accordingly
Experience with creating standards and documentation
Ability to work both independently or as part of a project group, with time constraints
Strong customer service oriented; organizational and communication skills, positive and can-do attitude
A technical troubleshooting and prioritization skills test will be part of the interview process.
,

Employement Category:

Contact Details:

+ View Contact

×

Login

Candidates can login here to view contacts and apply.

Sign In Sign Up

Email:

Password:

Password too short

To create your profile, apply for a job or make a registration

Sign In Close

Your name (*)

Email (*)

Mobile (*)

Preferred City (* max. 2 w/comma)

Designation / Expected Role

Current / Recent Company (*)

Experience (*)

0 - 1 Yrs 1 - 2 Yrs 2 - 3 Yrs 3 - 4 Yrs 4 - 5 Yrs 5 - 6 Yrs 6 - 7 Yrs 7 - 8 Yrs 8 - 9 Yrs 9 - 10 Yrs 10 - 11 Yrs 11 - 12 Yrs 12 - 13 Yrs 13 - 14 Yrs 14 - 15 Yrs 15 - 16 Yrs 16 - 17 Yrs 17 - 18 Yrs 18 - 19 Yrs 19 - 20 Yrs 20 - 21 Yrs 21 - 22 Yrs 22 - 23 Yrs 23 - 24 Yrs 24 - 25 Yrs 25 - 26 Yrs 26 - 27 Yrs 27 - 28 Yrs 28 - 29 Yrs 29 - 30 Yrs 30+ Yrs

Expected Salary (*)

Rs 0 - 50K PM Rs 50K - 1 LPA Rs 1.0 - 1.5 LPA Rs 1.5 - 2.0 LPA Rs 2.0 - 2.5 LPA Rs 2.5 - 3.0 LPA Rs 3.0 - 3.5 LPA Rs 3.5 - 4.0 LPA Rs 4.0 - 4.5 LPA Rs 4.5 - 5.0 LPA Rs 5 - 6 LPA Rs 6 - 7 LPA Rs 7 - 8 LPA Rs 8 - 9 LPA Rs 9 - 10 LPA Rs 10 - 12 LPA Rs 12 - 14 LPA Rs 14 - 16 LPA Rs 16 - 18 LPA Rs 18 - 20 LPA Rs 20 - 22 LPA Rs 22 - 24 LPA Rs 24 - 26 LPA Rs 26 - 28 LPA Rs 28 - 30 LPA Rs 30 - 32 LPA Rs 32 - 34 LPA Rs 34 - 36 LPA Rs 36 - 38 LPA Rs 38 - 40 LPA Rs 40 - 42 LPA Rs 42 - 44 LPA Rs 44 - 46 LPA Rs 46 - 48 LPA Rs 48 - 50 LPA Rs 50 - 75 LPA Rs 75 Lakh - 1C PA Rs 1 Crore+ PA

Desired Industry (*):

Accounting / Finance Advertising / MR / PR / Events Agriculture / Dairy Animation / Multimedia Architecture / Interior Design Astrology Automobile / Auto Ancillaries / Auto Components Aviation / Airline / Aerospace / Aeronautical Banking / Financial Services / Broking BPO / Call Center / ITeS Brewery / Distillery Broadcasting Cement / Building Material Chemical / Petro / Plastic / Rubber / Glass Consumer Electronics / Appliances / Durables Courier / Transportation / Freight Defence / Government Education / Teaching / Training Electricals / Switchgears Engineering / Construction / Cement / Metals Environment / Waste Management Export / Import / Trading Facility Management Fertilizers / Pesticides FMCG / Foods / Beverage Food Processing Furnishings / Ceramics / Sanitaryware / Electricals Gems / Jewellery Gifts / Toys / Stationary Government / Departmental Heat Ventilation / Air Conditioning Hotel / Restaurant Industrial Design Industrial Products / Heavy Machinery Insurance Internet / E-Commerce IT - Hardware / Networking IT - Software / Services KPO / Research / Analytics Leather / Leather Products Legal / Courts Logistics / Courier / Transportation Management Consulting / Strategy Manufacturing / Production Matrimony / Matchmaking Media / Entertainment Medical / Healthcare / Hospital Merchant Navy Metal / Iron / Steel MFI - Micro Finance Military / Police / Arms Ammunition Mining / Quarrying NBFC-Non Banking Financial Services NGO / Social Work Office Equipment / Automation Not Mentioned Paint / Art / Sculpture / Craft Paper / Wood Personal Care / Beauty Pharma / Biotech / Clinical Research Politics Power / Energy / Oil / Gas / Petroleum Printing / Publishing / Packaging Quality Certification Real Estate / Property Recruitment Services / RPO Religion / Spirituality Retail Security / Detective Services Semiconductors / Electronics Shipping / Marine Telecom / ISP Textile / Garments / Fashion Travel / Tourism / Hotels / Airlines / Railways Unskilled Labor / Domestic Help Veterinary Science / Pet Care Sports / Fitness / Beauty

Functional area / Department (*):

Accounts / Finance / Tax / CS / Audit Agent / Agency Analytics & Business Intelligence Architecture / Interior Design Banking / Insurance Beauty / Fitness / Spa Services Content / Journalism Corporate Planning / Consulting CSR & Sustainability Engineering Design / R&D Export / Import / Merchandising Fashion / Garments / Merchandising Guards / Security Services Hotels / Restaurants HR / Administration / IR IT- Hardware / Telecom / Technical Staff / Support IT Software - Application Programming / Maintenance IT Software - Client Server IT Software - DBA / Datawarehousing IT Software - E-Commerce / Internet Technologies IT Software - Embedded /EDA /VLSI /ASIC /Chip Des. IT Software - ERP / CRM IT Software - Mainframe IT Software - Middleware IT Software - Mobile IT Software - Network Administration / Security IT Software - Other IT Software - QA & Testing IT Software - System Programming IT Software - Systems / EDP / MIS IT Software - Telecom Software ITES / BPO / KPO / Customer Service / Operations Legal Marketing / Advertising / MR / PR Pharma / Biotech / Healthcare / Medical / R&D Packaging Production / Maintenance / Quality Purchase / Logistics / Supply Chain Sales / BD Secretary / Front Office / Data Entry Self Employed / Consultants Shipping Site Engineering / Project Management Teaching / Education Top Management Ticketing / Travel / Airlines TV / Films / Production Web / Graphic Design / Visualiser Other Areas

Enter Skills (key skills, subjects, technologies & roles to use in search)

Write briefly about yourself, your experience and education (*)

Attach Resume  Max 2.38 MB (RTF, PDF, DOC, DOCX formats only parsed)

Please, check the file size and type.

Add social media [ + ]

Create password

I agree with website service terms and conditions

Sign Up Close

Candidates are expected to provide most recent and accurate profile information, inappropriate content is strictly prohibited!