Senior Database Developer Resume
2.00/5 (Submit Your Rating)
New York, NY
SUMMARY:
- Professional who designs and build databases that support business applications and ensure system scalability, security, performance and reliability. Develop database architectural strategies at modeling, design and implementation stages that address business or industry requirements. Develop data models for applications, metadata tables, views or related database structures. Research, design, develop and test software. Set up database clusters, backup or recovery processes. Consider relative costs / benefits of potential actions and choose most appropriate one. Apply principles and techniques of computer science, engineering and mathematical analysis. Passion for new technologies and services. Areas of expertise include:
TECHNICAL SKILLS:
MS SQL Server 6.5: 2016, Microsoft .NET, VMware
Tools: PowerDesigner, Erwin Data Modeler, Embarcadero ER / Studio, SSIS, MS Visual Studio, C#, PowerShell, JavaScript, Team Foundation Server, SqLite
PROFESSIONAL EXPERIENCE:
Confidential, New York, NY
Senior Database Developer
- Drove data warehouse project development by designing and implementing staging tables for ETL process.
- Made code more readable and helped avoid common mistakes by writing SQL coding guidelines and standards for development team to implement best practice guidelines.
- Enabled troubleshooting of invalid files from vendors by developing file parsing utilities with C#.
Confidential, Jersey City, NJ
Senior Database Engineer
- Automated SSIS deployment by developing deployment script with PowerShell.
- Fixed performance problems by tuning Oracle and SQL server query.
Confidential , New York, NY
Senior Database Engineer
- Served as Senior Database Engineer. Developed SQL Coding Standard and Guideline. Implemented SQL Server policy with PowerShell. Migrated database from SQL 2005 to SQL Server 2012 with code optimization. Developed PowerShell scripts to copy database schema and lookup table data from production to UAT and QA. Partitioned big table with a time - based sliding window. Implemented missing and unused indexes reports.
- Made certain business and industry requirements were understood and met by collaborating with system architects, software architects and design analysts.
Confidential
Database Engineer
- Allowed calculation of trade date time world-wide by leading, designing and implementing IANA time zone database on SQL server using Erwin Data Modeler. Created custom C# program for parsing ETL IANA files.
- Expanded database development by creating logical and physical data models for SQL server 2008 and SQL server 2012 databases using PowerDesigner.
Confidential
Senior Database Analyst
- Enabled encryption of client data by implementing Transparent Data Encryption (TDE) for databases and encrypting connections to SQL server with SSL.
- Improved database performance by creating, monitoring and maintaining complex maintenance plans (index fragmentation, appropriate backup strategies and software and database partitioning).
Confidential
Database Administrator
- Implemented software reusability principles by writing reusable code in T-SQL and C# based on best practices and adopted standards.
- Created data warehouse by developing OLAP solution using SSRS, SSIS, Visual Studio, C# and Embarcadero ER / Studio for Microsoft SQL Server 2008.
Confidential
Developer
- Contributed to team development of MA3000 docketing and calendaring system utilized by top law firms nationwide by strategically utilizing knowledge base.
- Added to development of data warehouse by skillfully using PowerDesigner, Oracle 9i, ASP.NET, SSRS, Delphi and C#; handled extract, transform and load (ETL) program development.