Discovery sessions to identify, troubleshoot, document, and resolve database performance issues.
Perform Query Optimization Tasks.
Develop Complex SQL Scripts and Perform database archiving based on certain parameters.
Develop stored procedures, views, custom functions, triggers, and cursors.
Oracle to SQL transitions and vice versa
Perform Database Schema comparisons – reference vs actual.
Index utilization reporting
Collaborate with Development Team, Application Support and QA teams to resolve database issues affecting application modules.
Troubleshoot DB response times and tune queries accordingly
Work with the Product Line Manager to ensure a strict adherence to our SLA and rule out items not coming under Maintenance Contracts.
Communicate effectively with management.
Develop good working relationships with internal teams.
Bachelors Degree in Information Systems, Computer Engineering or equivalent technical Degree; or equivalent combination of education and experience.
Minimum 5+ years of programming or complex T-SQL scripting experience.
Experience using tools as TOAD, SQL Developer.
Ability to comfortably deliver training or conduct meetings in front of a group of people
Strong troubleshooting skills and analytical thinking to resolve issues.
Positive, proactive, take charge attitude and attention to detail.
Strong time management skills with the ability to meet deadlines for multiple, concurrent projects.
The candidate should have excellent verbal and written communication skills
The candidate may be required to work after-hours or on weekends up to 20% of the time
PowerShell experience for SQL Server and Azure.
Basic Database Administration in SQL Server and Oracle
Basic understanding of Active Directory.
Understanding of mapping applications, ArcGIS, Google/Bing Maps
Medical Coverage – Self & Dependents
Parents Medical Coverage
Employee Performance-based bonuses
Home Internet Subsidy
Profit Sharing Plan [Tenured Employees Only]
Child Care Facility
Company Provided Lunch/Dinner
Professional Development Budget
Recreational area for in-house games
Sporadic On-shore training opportunities
Friendly work environment