Anil Maram

Senior Database Administrator with 7+ years of experience supporting SQL Server, DB2, and Oracle environments, with strong expertise in logical and physical data modeling, DDL/DML script development, data conversion planning, data mapping, gap analysis, and enterprise database support. Skilled in creating and maintaining tables, views, indexes, triggers, stored procedures, and writing complex SQL queries against SQL Server and DB2 databases. Experienced in SQL performance tuning, query optimization, execution plan review, indexing strategies, and data validation.

Hands-on experience with SSMS, SSIS, SSRS, ER Studio Data Architect, QMF for Workstation, Redgate SQL Compare, Export/Import utilities, TSO, SQL, and PL/SQL. Strong collaborator with project managers, solution architects, business analysts, developers, QA teams, and stakeholders to deliver accurate database designs, validated data solutions, and clear technical documentation.

Data Modeling Specialist - Johnson & Johnson - New Brunswick, NJ

(2025-05)

Designed and developed logical and physical data models for enterprise applications, ensuring scalable database structures aligned with business rules, application workflows, and reporting requirements.

• Created and maintained DDL scripts for tables, views, indexes, triggers, stored procedures, and database objects across development, QA, UAT, and production environments.
• Developed complex DML SQL scripts to support data updates, data transformation, data correction, validation, reconciliation, and reporting needs across enterprise database systems.
• Prepared and maintained data conversion strategy plans, data mapping documents, gap analysis specifications, and source-to-target mapping documentation for application modernization and migration initiatives.
• Worked with project managers, solution architects, business analysts, application development teams, QA teams, and business stakeholders to review requirements and ensure quality of DDL/DML scripts.
• Performed SQL performance tuning by analyzing execution plans, indexes, stored procedures, query logic, joins, statistics, and database access patterns to improve query efficiency.
• Supported data movement, export/import processes, database refreshes, and validation activities to ensure accurate and consistent data across multiple environments.
• Used ER Studio Data Architect to design, update, and document logical and physical data models, entity relationships, data definitions, and database structures.
• Supported reporting and data integration processes using SSIS, SSRS, SQL Server Management Studio, QMF for Workstation, Redgate SQL Compare, and TSO.
• Created clear technical documentation describing data models, database objects, data usage, conversion rules, validation results, and application process flows.
• Investigated and resolved database-related issues, data discrepancies, SQL errors, performance problems, and deployment defects in collaboration with development and QA teams.
• Participated in database change management, release support, script validation, production deployment planning, and post-deployment verification to ensure stable database operations.

Data Modeling Specialist - JPMorgan Chase - Plano, TX

(2022-06 - 2025-03)

Designed and developed logical and physical data models for enterprise banking applications, supporting data architecture, application workflows, reporting needs, and business rule implementation.

• Created, reviewed, and maintained DDL scripts for tables, views, indexes, triggers, stored procedures, and database objects across Development, QA, UAT, and Production environments.
• Wrote complex DML SQL queries and scripts against SQL Server and DB2 databases to support data manipulation, validation, reconciliation, reporting, and application processing requirements.
• Developed and maintained data conversion strategy plans, data mapping documents, gap analysis specifications, and source-to-target mapping documentation for database migration and modernization initiatives.
• Worked closely with project managers, solution architects, business analysts, application development teams, QA teams, and business stakeholders to validate database requirements and ensure script quality.
• Performed SQL performance tuning for complex SQL queries, stored procedures, joins, indexes, execution plans, statistics, and database access patterns to improve application efficiency.
• Supported database implementation, data movement, export/import processes, environment refreshes, and release activities while ensuring data accuracy and deployment readiness.
• Used ER Studio Data Architect to maintain logical and physical data models, entity relationships, data definitions, and database design documentation.
• Supported reporting, data integration, and database comparison activities using SSMS, SSMS Job Scheduler, SSIS, SSRS, QMF for Workstation, Redgate SQL Compare, and TSO.
• Investigated and resolved database issues, SQL errors, data discrepancies, performance bottlenecks, and deployment defects across enterprise database environments.
• Created clear and accurate documentation for data models, database objects, data usage, conversion rules, validation results, and application process flows.
• Participated in change management, production deployment planning, script validation, release support, defect resolution, and post-deployment verification to maintain stable database operations.

Database Administrator - Walmart - Bentonville, AR

(2021-05 - 2022-05)

Supported enterprise SQL Server environments for Walmart's retail, e-commerce, inventory management, supply chain, and point-of-sale (POS) applications across Production, QA, UAT, and Development environments.

• Planned and executed database migration projects from on-premises SQL Server environments to AWS RDS for SQL Server, ensuring minimal downtime and data integrity.
• Worked closely with application developers and DevOps teams to support CI/CD database deployments, schema versioning, and release automation using Azure DevOps and Git.
• Designed and implemented database partitioning, compression, and archival strategies to improve query performance and efficiently manage large transactional datasets.
• Optimized ETL workloads by collaborating with data engineering teams, reducing batch processing time and improving data availability for business reporting.
• Configured and monitored AWS RDS parameter groups, option groups, snapshots, maintenance windows, Multi-AZ deployments, and storage auto-scaling.
• Developed PowerShell and T-SQL automation scripts to streamline environment provisioning, database health reporting, maintenance scheduling, and operational monitoring.
• Performed database performance analysis using Extended Events, Query Store, and Dynamic Management Views (DMVs), identifying bottlenecks and recommending tuning strategies.
• Collaborated with cybersecurity teams to implement database auditing, encryption, vulnerability remediation, and compliance controls for sensitive retail customer data.
• Partnered with infrastructure and cloud engineering teams to optimize SQL Server resource utilization, storage allocation, and high-availability configurations across enterprise environments.

Database Administrator - Vodafone Idea Limited - Hyderabad, India

(2020-11 - 2021-04)

Administered SQL Server 2017/2019 production databases supporting telecom billing, CRM, subscriber, and network management systems.

• Configured and maintained Always On Availability Groups, Log Shipping, and Replication to ensure high availability and disaster recovery.