Ask ITC Inc. is a software development Company. Our passion is delivering technology strategies & digital solutions that assist our clients with building competitive, innovative and successful companies.
The Senior DBA MUST be proactive in improving the database, technical processes and customer relationships.Specific tasks may include but are not limited to:•Assist with the design of a highly available fault tolerant database infrastructure •Assist with technical design activities, including optimizing data access for a web portal application, leveraging features in SQL to reduce latency, and providing insights that could improve application performance•Creation and maintenance of Application objects (For ex. Type of tables and indexes, Partition types/keys, foreign keys/constraints, segment type and size etc.)•Creation of processes to replicate production databases (de-normalized to normalized)•Help with layout application schemas and tablespaces•Define and maintain database roles and permissions for Application objects•Develop and execute statistics collection plan for application objects depending on volume and type of queries (For ex. Timing of statistics collections, Lock statistics, enable/disable HISTOGRAM etc.)•Review backup policy with System DBA and help suggest schedule/timings to avoid conflict with application processes•Review SQL execution plans on critical application queries•Help with Application code testing during application releases or DB upgrade/migration to avoid SQL performance issues•Bulk data uploads•Assist with infrastructure optimization and design, including identifying bottlenecks, improving responsiveness, and reducing single points of failure.
Knowledge of Ghost Imaging software will be a plus
Skills Required
- At least 10 years of experience as a SQL DBA
- Design and maintain highly available, fault-tolerant database infrastructure
- Performance tuning and optimization of SQL and database access for web applications
- Creation and maintenance of application database objects (tables, indexes, partitions, constraints)
- Design processes to replicate production databases (de-normalized to normalized)
- Layout application schemas and tablespaces
- Define and maintain database roles and permissions
- Develop and execute statistics collection plans (timing, histograms, lock stats)
- Review and advise on backup policies and schedules with System DBAs
- Analyze SQL execution plans and advise on query tuning
- Assist with application code testing during releases and DB upgrades/migrations
- Perform bulk data uploads and related ETL/ingestion tasks
- Assist with infrastructure optimization, bottleneck identification, and reducing single points of failure
- Knowledge of Ghost Imaging software
What We Do
Ask IT Consulting Inc. is a global information technology management firm founded in 2008 and headquartered in Holtsville, NY. The company specializes in providing comprehensive technology and workforce solutions, including IT consulting, talent management, and digital services. Their expertise extends to cybersecurity, cloud computing, and IT staffing, focusing on delivering tailored, innovative, and effective solutions to meet the unique objectives of their diverse clients.
